DBA Data[Home] [Help]

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on WSH_SERIAL_NUMBERS

Line 67: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,

63: );
64:
65: TYPE SHIP_LINES_Rec_Type IS RECORD
66: (
67: shipped_serial_num wsh_serial_numbers.fm_serial_number%type,
68: lot_number wsh_delivery_details.lot_number%type ,
69: revision wsh_delivery_details.revision%type ,
70: subinv wsh_delivery_details.subinventory%type ,
71: requested_quantity wsh_delivery_details.requested_quantity%type,

Line 107: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,

103: inventory_item_id oe_order_lines_all.inventory_item_id%type,
104: shipment_date oe_order_lines_all.actual_shipment_date%type ,
105: delivery_detail_id wsh_delivery_details.delivery_detail_id%type,
106: shipped_quantity wsh_delivery_details.shipped_quantity%type,
107: del_line_serial_num wsh_serial_numbers.fm_serial_number%type ,
108: lot_number wsh_delivery_details .lot_number%type,
109: subinventory wsh_delivery_details .subinventory%type,
110: locator_id wsh_delivery_details .locator_id%type,
111: organization_id wsh_delivery_details .organization_id%type,

Line 6186: wsh_serial_numbers dsn,--Added to fix 3801614

6182: csd_product_transactions cpt,
6183: cs_estimate_details ced,
6184: csd_repairs cra,
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,

Line 6262: wsh_serial_numbers dsn,--Added to fix 3801614

6258: csd_product_transactions cpt,
6259: cs_estimate_details ced,
6260: csd_repairs cra,
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,

Line 6346: wsh_serial_numbers dsn,--Added to fix 3801614

6342: csd_product_transactions cpt,
6343: cs_estimate_details ced,
6344: csd_repairs cra,
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,

Line 7038: wsh_serial_numbers dsn,--Added to fix 3801614

7034: hao1.name destination_org_name,
7035: trl.txn_source_id
7036: from oe_order_lines_all oel,
7037: wsh_delivery_details dd,
7038: wsh_serial_numbers dsn,--Added to fix 3801614
7039: po_requisition_lines_all prl,
7040: po_requisition_headers_all prh,
7041: mtl_system_items mtl,
7042: hr_all_organization_units hao,

Line 7095: wsh_serial_numbers dsn,--Added to fix 3801614

7091: hao1.name destination_org_name,
7092: trl.txn_source_id
7093: from oe_order_lines_all oel,
7094: wsh_delivery_details dd,
7095: wsh_serial_numbers dsn,--Added to fix 3801614
7096: po_requisition_lines_all prl,
7097: po_requisition_headers_all prh,
7098: mtl_system_items mtl,
7099: hr_all_organization_units hao,