DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 1484: WSH_DELIVERY_ASSIGNMENTS_V wdass,

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
1488: AND wdass.delivery_id = wleg.delivery_id

Line 1520: WSH_DELIVERY_ASSIGNMENTS_V wdass,

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
1524: AND wdass.delivery_id = wleg.delivery_id

Line 3181: WSH_DELIVERY_ASSIGNMENTS_V wdass,

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
3185: AND wdass.delivery_id = wleg.delivery_id