eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 126: serial_number_control_code mtl_system_items.serial_number_control_code%type,

122: source_organization_id po_requisition_lines_all.source_organization_id%type,
123: source_subinventory po_requisition_lines_all.source_subinventory%type,
124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
126: serial_number_control_code mtl_system_items.serial_number_control_code%type,
127: lot_control_code mtl_system_items.lot_control_code%type,
128: requisition_number po_requisition_headers_all.segment1%type ,
129: source_org_name hr_all_organization_units.name%type ,
130: destination_org_name hr_all_organization_units.name%type ,

Line 127: lot_control_code mtl_system_items.lot_control_code%type,

123: source_subinventory po_requisition_lines_all.source_subinventory%type,
124: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
125: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
126: serial_number_control_code mtl_system_items.serial_number_control_code%type,
127: lot_control_code mtl_system_items.lot_control_code%type,
128: requisition_number po_requisition_headers_all.segment1%type ,
129: source_org_name hr_all_organization_units.name%type ,
130: destination_org_name hr_all_organization_units.name%type ,
131: txn_source_id mtl_txn_request_lines.txn_source_id%type

Line 151: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type

147: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
148: date_completed WIP_DISCRETE_JOBS.date_completed%type,
149: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
150: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
151: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type
152:
153: );
154:
155: TYPE JOB_CREATION_Rec_Type IS RECORD

Line 754: MTL_SYSTEM_ITEMS mtl

750: from CSD_REPAIR_JOB_XREF crj,
751: CSD_REPAIRS cra,
752: WIP_DISCRETE_JOBS wdj,
753: WIP_ENTITIES we,
754: MTL_SYSTEM_ITEMS mtl
755: where wdj.wip_entity_id = crj.wip_entity_id
756: and we.wip_entity_id = wdj.wip_entity_id
757: and crj.repair_line_id = cra.repair_line_id
758: and crj.organization_id = mtl.organization_id

Line 790: MTL_SYSTEM_ITEMS mtl

786: from CSD_REPAIR_JOB_XREF crj,
787: CSD_REPAIRS cra,
788: WIP_DISCRETE_JOBS wdj,
789: WIP_ENTITIES we,
790: MTL_SYSTEM_ITEMS mtl
791: where wdj.wip_entity_id = crj.wip_entity_id
792: and we.wip_entity_id = wdj.wip_entity_id
793: and crj.repair_line_id = cra.repair_line_id
794: and crj.organization_id = mtl.organization_id

Line 2143: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;

2139: l_dummy varchar2(30);
2140: l_lot_number mtl_lot_numbers.lot_number%type;
2141: l_ro_reject_qty NUMBER;
2142: l_commit_size NUMBER := 500;
2143: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
2144: l_lot_ctl_code mtl_system_items.lot_control_code%type;
2145: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
2146: l_instance_id csi_item_instances.instance_id%type;
2147: l_prod_txn_status csd_product_transactions.prod_txn_status%type;

Line 2144: l_lot_ctl_code mtl_system_items.lot_control_code%type;

2140: l_lot_number mtl_lot_numbers.lot_number%type;
2141: l_ro_reject_qty NUMBER;
2142: l_commit_size NUMBER := 500;
2143: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
2144: l_lot_ctl_code mtl_system_items.lot_control_code%type;
2145: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
2146: l_instance_id csi_item_instances.instance_id%type;
2147: l_prod_txn_status csd_product_transactions.prod_txn_status%type;
2148:

Line 2145: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;

2141: l_ro_reject_qty NUMBER;
2142: l_commit_size NUMBER := 500;
2143: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
2144: l_lot_ctl_code mtl_system_items.lot_control_code%type;
2145: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
2146: l_instance_id csi_item_instances.instance_id%type;
2147: l_prod_txn_status csd_product_transactions.prod_txn_status%type;
2148:
2149: -- activity record

Line 2664: from mtl_system_items

2660: comms_nl_trackable_flag
2661: into l_srl_ctl_code,
2662: l_lot_ctl_code,
2663: l_ib_flag
2664: from mtl_system_items
2665: where inventory_item_id = i.inventory_item_id
2666: and organization_id = i.organization_id;
2667: Exception
2668: When no_data_found then

Line 3384: mtl_system_items mtl,

3380: hao.name org_name
3381: from rcv_transactions rcv,
3382: po_requisition_lines_all prl,
3383: po_requisition_headers_all prh,
3384: mtl_system_items mtl,
3385: hr_all_organization_units hao
3386: where rcv.requisition_line_id = prl.requisition_line_id
3387: and prl.item_id = mtl.inventory_item_id
3388: and prl.destination_organization_id = mtl.organization_id

Line 4800: mtl_system_items mtl,

4796: hao.name org_name
4797: from rcv_transactions rcv,
4798: po_requisition_lines_all prl,
4799: po_requisition_headers_all prh,
4800: mtl_system_items mtl,
4801: hr_all_organization_units hao
4802: where rcv.requisition_line_id = prl.requisition_line_id
4803: and prl.item_id = mtl.inventory_item_id
4804: and prl.destination_organization_id = mtl.organization_id

Line 6620: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;

6616: l_total_records NUMBER;
6617: l_dummy varchar2(30);
6618: l_commit_size NUMBER := 500;
6619: l_instance_id csi_item_instances.instance_id%type;
6620: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
6621: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
6622:
6623: -- activity record
6624: l_activity_rec activity_rec_type;

Line 6621: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;

6617: l_dummy varchar2(30);
6618: l_commit_size NUMBER := 500;
6619: l_instance_id csi_item_instances.instance_id%type;
6620: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
6621: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
6622:
6623: -- activity record
6624: l_activity_rec activity_rec_type;
6625:

Line 6811: from mtl_system_items

6807: select serial_number_control_code,
6808: comms_nl_trackable_flag
6809: into l_srl_ctl_code,
6810: l_ib_flag
6811: from mtl_system_items
6812: where inventory_item_id = i.inventory_item_id
6813: and organization_id = i.organization_id;
6814: Exception
6815: When no_data_found then

Line 7333: mtl_system_items mtl,

7329: wsh_delivery_details dd,
7330: wsh_serial_numbers dsn,--Added to fix 3801614
7331: po_requisition_lines_all prl,
7332: po_requisition_headers_all prh,
7333: mtl_system_items mtl,
7334: hr_all_organization_units hao,
7335: hr_all_organization_units hao1,
7336: mtl_txn_request_lines trl
7337: where oel.header_id = p_ord_header_id

Line 7390: mtl_system_items mtl,

7386: wsh_delivery_details dd,
7387: wsh_serial_numbers dsn,--Added to fix 3801614
7388: po_requisition_lines_all prl,
7389: po_requisition_headers_all prh,
7390: mtl_system_items mtl,
7391: hr_all_organization_units hao,
7392: hr_all_organization_units hao1,
7393: mtl_txn_request_lines trl
7394: where oel.line_id = dd.source_line_id