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 119: serial_number_control_code mtl_system_items.serial_number_control_code%type,

115: source_organization_id po_requisition_lines_all.source_organization_id%type,
116: source_subinventory po_requisition_lines_all.source_subinventory%type,
117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
119: serial_number_control_code mtl_system_items.serial_number_control_code%type,
120: lot_control_code mtl_system_items.lot_control_code%type,
121: requisition_number po_requisition_headers_all.segment1%type ,
122: source_org_name hr_all_organization_units.name%type ,
123: destination_org_name hr_all_organization_units.name%type ,

Line 120: lot_control_code mtl_system_items.lot_control_code%type,

116: source_subinventory po_requisition_lines_all.source_subinventory%type,
117: destination_organization_id po_requisition_lines_all.destination_organization_id%type,
118: destination_subinventory po_requisition_lines_all.destination_subinventory%type,
119: serial_number_control_code mtl_system_items.serial_number_control_code%type,
120: lot_control_code mtl_system_items.lot_control_code%type,
121: requisition_number po_requisition_headers_all.segment1%type ,
122: source_org_name hr_all_organization_units.name%type ,
123: destination_org_name hr_all_organization_units.name%type ,
124: txn_source_id mtl_txn_request_lines.txn_source_id%type

Line 144: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type

140: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
141: date_completed WIP_DISCRETE_JOBS.date_completed%type,
142: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
143: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
144: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type
145:
146: );
147:
148: TYPE JOB_CREATION_Rec_Type IS RECORD

Line 747: MTL_SYSTEM_ITEMS mtl

743: from CSD_REPAIR_JOB_XREF crj,
744: CSD_REPAIRS cra,
745: WIP_DISCRETE_JOBS wdj,
746: WIP_ENTITIES we,
747: MTL_SYSTEM_ITEMS mtl
748: where wdj.wip_entity_id = crj.wip_entity_id
749: and we.wip_entity_id = wdj.wip_entity_id
750: and crj.repair_line_id = cra.repair_line_id
751: and crj.organization_id = mtl.organization_id

Line 783: MTL_SYSTEM_ITEMS mtl

779: from CSD_REPAIR_JOB_XREF crj,
780: CSD_REPAIRS cra,
781: WIP_DISCRETE_JOBS wdj,
782: WIP_ENTITIES we,
783: MTL_SYSTEM_ITEMS mtl
784: where wdj.wip_entity_id = crj.wip_entity_id
785: and we.wip_entity_id = wdj.wip_entity_id
786: and crj.repair_line_id = cra.repair_line_id
787: and crj.organization_id = mtl.organization_id

Line 2095: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;

2091: l_dummy varchar2(30);
2092: l_lot_number mtl_lot_numbers.lot_number%type;
2093: l_ro_reject_qty NUMBER;
2094: l_commit_size NUMBER := 500;
2095: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
2096: l_lot_ctl_code mtl_system_items.lot_control_code%type;
2097: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
2098: l_instance_id csi_item_instances.instance_id%type;
2099: l_prod_txn_status csd_product_transactions.prod_txn_status%type;

Line 2096: l_lot_ctl_code mtl_system_items.lot_control_code%type;

2092: l_lot_number mtl_lot_numbers.lot_number%type;
2093: l_ro_reject_qty NUMBER;
2094: l_commit_size NUMBER := 500;
2095: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
2096: l_lot_ctl_code mtl_system_items.lot_control_code%type;
2097: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
2098: l_instance_id csi_item_instances.instance_id%type;
2099: l_prod_txn_status csd_product_transactions.prod_txn_status%type;
2100:

Line 2097: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;

2093: l_ro_reject_qty NUMBER;
2094: l_commit_size NUMBER := 500;
2095: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
2096: l_lot_ctl_code mtl_system_items.lot_control_code%type;
2097: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
2098: l_instance_id csi_item_instances.instance_id%type;
2099: l_prod_txn_status csd_product_transactions.prod_txn_status%type;
2100:
2101: -- activity record

Line 2598: from mtl_system_items

2594: comms_nl_trackable_flag
2595: into l_srl_ctl_code,
2596: l_lot_ctl_code,
2597: l_ib_flag
2598: from mtl_system_items
2599: where inventory_item_id = i.inventory_item_id
2600: and organization_id = i.organization_id;
2601: Exception
2602: When no_data_found then

Line 3223: mtl_system_items mtl,

3219: hao.name org_name
3220: from rcv_transactions rcv,
3221: po_requisition_lines_all prl,
3222: po_requisition_headers_all prh,
3223: mtl_system_items mtl,
3224: hr_all_organization_units hao
3225: where rcv.requisition_line_id = prl.requisition_line_id
3226: and prl.item_id = mtl.inventory_item_id
3227: and prl.destination_organization_id = mtl.organization_id

Line 4639: mtl_system_items mtl,

4635: hao.name org_name
4636: from rcv_transactions rcv,
4637: po_requisition_lines_all prl,
4638: po_requisition_headers_all prh,
4639: mtl_system_items mtl,
4640: hr_all_organization_units hao
4641: where rcv.requisition_line_id = prl.requisition_line_id
4642: and prl.item_id = mtl.inventory_item_id
4643: and prl.destination_organization_id = mtl.organization_id

Line 6418: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;

6414: l_total_records NUMBER;
6415: l_dummy varchar2(30);
6416: l_commit_size NUMBER := 500;
6417: l_instance_id csi_item_instances.instance_id%type;
6418: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
6419: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
6420:
6421: -- activity record
6422: l_activity_rec activity_rec_type;

Line 6419: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;

6415: l_dummy varchar2(30);
6416: l_commit_size NUMBER := 500;
6417: l_instance_id csi_item_instances.instance_id%type;
6418: l_ib_flag mtl_system_items.comms_nl_trackable_flag%type;
6419: l_srl_ctl_code mtl_system_items.serial_number_control_code%type;
6420:
6421: -- activity record
6422: l_activity_rec activity_rec_type;
6423:

Line 6579: from mtl_system_items

6575: select serial_number_control_code,
6576: comms_nl_trackable_flag
6577: into l_srl_ctl_code,
6578: l_ib_flag
6579: from mtl_system_items
6580: where inventory_item_id = i.inventory_item_id
6581: and organization_id = i.organization_id;
6582: Exception
6583: When no_data_found then

Line 7041: mtl_system_items mtl,

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,
7043: hr_all_organization_units hao1,
7044: mtl_txn_request_lines trl
7045: where oel.header_id = p_ord_header_id

Line 7098: mtl_system_items mtl,

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,
7100: hr_all_organization_units hao1,
7101: mtl_txn_request_lines trl
7102: where oel.line_id = dd.source_line_id