APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on WSH_NEW_DELIVERIES

Line 99: delivery_name wsh_new_deliveries.name%type ,

95: prod_txn_serial_num csd_product_transactions.source_serial_number%type ,
96: source_instance_id csd_product_transactions.source_instance_id%type,
97: product_transaction_id csd_product_transactions.product_transaction_id%type,
98: action_code csd_product_transactions.action_code%type,
99: delivery_name wsh_new_deliveries.name%type ,
100: org_name hr_all_organization_units.name%type
101: );
102: TYPE IO_SHIP_LINES_Rec_Type IS RECORD
103: (

Line 6389: wsh_new_deliveries wnd,

6385: wsh_delivery_details dd ,
6386: wsh_serial_numbers dsn,--Added to fix 3801614
6387: --Changed to view from table, bug: 4341784
6388: wsh_delivery_assignments_v wda,
6389: wsh_new_deliveries wnd,
6390: oe_order_lines_all oel,
6391: hr_all_organization_units hao
6392: Where cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6393: AND cpt.estimate_detail_id = ced.estimate_detail_id

Line 6466: wsh_new_deliveries wnd,

6462: wsh_delivery_details dd ,
6463: wsh_serial_numbers dsn,--Added to fix 3801614
6464: --Changed to view from table, bug: 4341784
6465: wsh_delivery_assignments_v wda,
6466: wsh_new_deliveries wnd,
6467: oe_order_lines_all oel,
6468: hr_all_organization_units hao
6469: Where cra.creation_date between p_from_date and p_to_date
6470: AND cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship

Line 6551: wsh_new_deliveries wnd,

6547: wsh_delivery_details dd ,
6548: wsh_serial_numbers dsn,--Added to fix 3801614
6549: --Changed to view from table, bug: 4341784
6550: wsh_delivery_assignments_v wda,
6551: wsh_new_deliveries wnd,
6552: oe_order_lines_all oel,
6553: hr_all_organization_units hao
6554: Where cpt.action_type in ('SHIP', 'SHIP_THIRD_PTY') -- Walk-in-issue will be changed to ship
6555: AND cpt.estimate_detail_id = ced.estimate_detail_id