MSC_SO_FULFILL_LINES_RC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
FULFILL_LINE_ID FULFILL_ORG_INSTANCE_ID CUSTOMER_SITE_ID ITEM_ID PROMISING_TYPE REQUESTED_DATE SCHEDULE_ARRIVAL_DATE SCHEDULE_SHIP_DATE ORDERED_QTY ORCH_ORDER_HEADER_ID ORCH_ORDER_LINE_ID ORDERED_UOM FULFILL_ORG_ID SOURCE_ORG_ID RESERVATION_QUANTITY DEMAND_CLASS RESERVATION_DATE CARRIER SERVICE SHIP_MODE_OF_TRANSPORT

Name

FULFILL_LINE_ID

FULFILL_ORG_INSTANCE_ID

CUSTOMER_SITE_ID

ITEM_ID

PROMISING_TYPE

REQUESTED_DATE

SCHEDULE_ARRIVAL_DATE

SCHEDULE_SHIP_DATE

ORDERED_QTY

ORCH_ORDER_HEADER_ID

ORCH_ORDER_LINE_ID

ORDERED_UOM

FULFILL_ORG_ID

SOURCE_ORG_ID

RESERVATION_QUANTITY

DEMAND_CLASS

RESERVATION_DATE

CARRIER

SERVICE

SHIP_MODE_OF_TRANSPORT

Query

SQL_Statement
select "FULFILL_LINE_ID","FULFILL_ORG_INSTANCE_ID","CUSTOMER_SITE_ID","ITEM_ID","PROMISING_TYPE","REQUESTED_DATE","SCHEDULE_ARRIVAL_DATE","SCHEDULE_SHIP_DATE","ORDERED_QTY","ORCH_ORDER_HEADER_ID","ORCH_ORDER_LINE_ID","ORDERED_UOM","FULFILL_ORG_ID","SOURCE_ORG_ID","RESERVATION_QUANTITY","DEMAND_CLASS","RESERVATION_DATE","CARRIER","SERVICE","SHIP_MODE_OF_TRANSPORT" from MSC_SO_FULFILL_LINES_V as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC','readscn'))

SQL_Statement

select "FULFILL_LINE_ID","FULFILL_ORG_INSTANCE_ID","CUSTOMER_SITE_ID","ITEM_ID","PROMISING_TYPE","REQUESTED_DATE","SCHEDULE_ARRIVAL_DATE","SCHEDULE_SHIP_DATE","ORDERED_QTY","ORCH_ORDER_HEADER_ID","ORCH_ORDER_LINE_ID","ORDERED_UOM","FULFILL_ORG_ID","SOURCE_ORG_ID","RESERVATION_QUANTITY","DEMAND_CLASS","RESERVATION_DATE","CARRIER","SERVICE","SHIP_MODE_OF_TRANSPORT" from MSC_SO_FULFILL_LINES_V

as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC','readscn'))