DBA Data[Home] [Help]

APPS.WSH_USA_ACTIONS_PVT dependencies on OE_DELIVERY_LINES_V

Line 3022: from oe_delivery_lines_v

3018: earliest_acceptable_date,
3019: earliest_ship_date, --equivalent of demand_satisfaction_date in TP
3020: order_date_type_code,
3021: source_document_type_id
3022: from oe_delivery_lines_v
3023: where ship_from_org_id is not NULL
3024: and order_quantity_uom is not NULL
3025: and ordered_quantity is not NULL;
3026:

Line 3119: from oe_delivery_lines_v

3115: earliest_acceptable_date,
3116: earliest_ship_date,
3117: order_date_type_code,
3118: source_document_type_id
3119: from oe_delivery_lines_v
3120: WHERE line_id = p_source_line_id
3121: and p_source_line_id IS NOT NULL
3122: and ship_from_org_id is not NULL
3123: and order_quantity_uom is not NULL

Line 3133: --FROM oe_delivery_lines_v

3129:
3130: CURSOR C_OE_LINES_REC_LOCK (c_line_id NUMBER) is
3131: SELECT line_id
3132: FROM oe_order_lines_all
3133: --FROM oe_delivery_lines_v
3134: WHERE line_id = c_line_id
3135: and nvl(shipping_interfaced_flag, 'N') = 'N'
3136: FOR UPDATE NOWAIT;
3137: