DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on OE_DELIVERY_LINES_V

Line 3334: from oe_delivery_lines_v

3330: earliest_acceptable_date,
3331: earliest_ship_date, --equivalent of demand_satisfaction_date in TP
3332: order_date_type_code,
3333: source_document_type_id
3334: from oe_delivery_lines_v
3335: where ship_from_org_id is not NULL
3336: and order_quantity_uom is not NULL
3337: and ordered_quantity is not NULL;
3338:

Line 3431: from oe_delivery_lines_v

3427: earliest_acceptable_date,
3428: earliest_ship_date,
3429: order_date_type_code,
3430: source_document_type_id
3431: from oe_delivery_lines_v
3432: WHERE line_id = p_source_line_id
3433: and p_source_line_id IS NOT NULL
3434: and ship_from_org_id is not NULL
3435: and order_quantity_uom is not NULL

Line 3445: --FROM oe_delivery_lines_v

3441:
3442: CURSOR C_OE_LINES_REC_LOCK (c_line_id NUMBER) is
3443: SELECT line_id
3444: FROM oe_order_lines_all
3445: --FROM oe_delivery_lines_v
3446: WHERE line_id = c_line_id
3447: and nvl(shipping_interfaced_flag, 'N') = 'N'
3448: FOR UPDATE NOWAIT;
3449: