DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on WSH_NEW_DELIVERIES

Line 92: delivery_name wsh_new_deliveries.name%type ,

88: prod_txn_serial_num csd_product_transactions.source_serial_number%type ,
89: source_instance_id csd_product_transactions.source_instance_id%type,
90: product_transaction_id csd_product_transactions.product_transaction_id%type,
91: action_code csd_product_transactions.action_code%type,
92: delivery_name wsh_new_deliveries.name%type ,
93: org_name hr_all_organization_units.name%type
94: );
95: TYPE IO_SHIP_LINES_Rec_Type IS RECORD
96: (

Line 6189: wsh_new_deliveries wnd,

6185: wsh_delivery_details dd ,
6186: wsh_serial_numbers dsn,--Added to fix 3801614
6187: --Changed to view from table, bug: 4341784
6188: wsh_delivery_assignments_v wda,
6189: wsh_new_deliveries wnd,
6190: oe_order_lines_all oel,
6191: hr_all_organization_units hao
6192: Where cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6193: AND cpt.estimate_detail_id = ced.estimate_detail_id

Line 6265: wsh_new_deliveries wnd,

6261: wsh_delivery_details dd ,
6262: wsh_serial_numbers dsn,--Added to fix 3801614
6263: --Changed to view from table, bug: 4341784
6264: wsh_delivery_assignments_v wda,
6265: wsh_new_deliveries wnd,
6266: oe_order_lines_all oel,
6267: hr_all_organization_units hao
6268: Where cra.creation_date between p_from_date and p_to_date
6269: AND cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship

Line 6349: wsh_new_deliveries wnd,

6345: wsh_delivery_details dd ,
6346: wsh_serial_numbers dsn,--Added to fix 3801614
6347: --Changed to view from table, bug: 4341784
6348: wsh_delivery_assignments_v wda,
6349: wsh_new_deliveries wnd,
6350: oe_order_lines_all oel,
6351: hr_all_organization_units hao
6352: Where cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6353: AND cpt.estimate_detail_id = ced.estimate_detail_id