DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on WSH_DELIVERY_LEGS

Line 1483: FROM WSH_DELIVERY_LEGS wleg,

1479: --Cursor to populate t_oe_header
1480: --
1481: CURSOR c_oe_header IS
1482: SELECT DISTINCT oelines.header_id, oelines.org_id
1483: FROM WSH_DELIVERY_LEGS wleg,
1484: WSH_DELIVERY_ASSIGNMENTS_V wdass,
1485: WSH_DELIVERY_DETAILS wdel,
1486: OE_ORDER_LINES_ALL oelines
1487: WHERE wleg.pick_up_stop_id = x_trip_stop_id

Line 1519: FROM WSH_DELIVERY_LEGS wleg,

1515: oelines.veh_cus_item_cum_key_id,
1516: oelines.source_document_id,
1517: oelines.source_document_line_id,
1518: oelines.org_id
1519: FROM WSH_DELIVERY_LEGS wleg,
1520: WSH_DELIVERY_ASSIGNMENTS_V wdass,
1521: WSH_DELIVERY_DETAILS wdel,
1522: OE_ORDER_LINES_ALL oelines
1523: WHERE wleg.pick_up_stop_id = x_trip_stop_id

Line 3180: FROM WSH_DELIVERY_LEGS wleg,

3176: SELECT oelines.sold_to_org_id,
3177: oelines.ship_to_org_id,
3178: oelines.intmed_ship_to_org_id,
3179: oelines.invoice_to_org_id
3180: FROM WSH_DELIVERY_LEGS wleg,
3181: WSH_DELIVERY_ASSIGNMENTS_V wdass,
3182: WSH_DELIVERY_DETAILS wdel,
3183: OE_ORDER_LINES oelines
3184: WHERE wleg.pick_up_stop_id = x_trip_stop_id