DBA Data[Home] [Help]

APPS.RLM_CUM_SV dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 1475: WSH_DELIVERY_ASSIGNMENTS_V wdass,

1471: --
1472: CURSOR c_oe_header IS
1473: SELECT DISTINCT oelines.header_id, oelines.org_id
1474: FROM WSH_DELIVERY_LEGS wleg,
1475: WSH_DELIVERY_ASSIGNMENTS_V wdass,
1476: WSH_DELIVERY_DETAILS wdel,
1477: OE_ORDER_LINES_ALL oelines
1478: WHERE wleg.pick_up_stop_id = x_trip_stop_id
1479: AND wdass.delivery_id = wleg.delivery_id

Line 1511: WSH_DELIVERY_ASSIGNMENTS_V wdass,

1507: oelines.source_document_id,
1508: oelines.source_document_line_id,
1509: oelines.org_id
1510: FROM WSH_DELIVERY_LEGS wleg,
1511: WSH_DELIVERY_ASSIGNMENTS_V wdass,
1512: WSH_DELIVERY_DETAILS wdel,
1513: OE_ORDER_LINES_ALL oelines
1514: WHERE wleg.pick_up_stop_id = x_trip_stop_id
1515: AND wdass.delivery_id = wleg.delivery_id

Line 3171: WSH_DELIVERY_ASSIGNMENTS_V wdass,

3167: oelines.ship_to_org_id,
3168: oelines.intmed_ship_to_org_id,
3169: oelines.invoice_to_org_id
3170: FROM WSH_DELIVERY_LEGS wleg,
3171: WSH_DELIVERY_ASSIGNMENTS_V wdass,
3172: WSH_DELIVERY_DETAILS wdel,
3173: OE_ORDER_LINES oelines
3174: WHERE wleg.pick_up_stop_id = x_trip_stop_id
3175: AND wdass.delivery_id = wleg.delivery_id