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.CSI_T_UTILITIES_PVT dependencies on MTL_SYSTEM_ITEMS

Line 533: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;

529: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
530: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
531:
532: l_mo_org_id oe_order_lines_all.org_id%TYPE;
533: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
534: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
535: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
536: l_loop_count number;
537: l_td_quantity number;

Line 534: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

530: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
531:
532: l_mo_org_id oe_order_lines_all.org_id%TYPE;
533: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
534: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
535: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
536: l_loop_count number;
537: l_td_quantity number;
538: l_uom varchar2(30);

Line 535: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;

531:
532: l_mo_org_id oe_order_lines_all.org_id%TYPE;
533: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
534: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
535: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
536: l_loop_count number;
537: l_td_quantity number;
538: l_uom varchar2(30);
539: l_item_type_code oe_order_lines_all.item_type_code%TYPE;

Line 706: FROM mtl_system_items_kfv

702: l_lot_control_code,
703: l_nl_trackable_flag,
704: l_txn_source_rec.primary_uom,
705: l_shippable_flag
706: FROM mtl_system_items_kfv
707: WHERE inventory_item_id = l_txn_source_rec.inventory_item_id
708: AND organization_id = l_txn_source_rec.organization_id;
709:
710: EXCEPTION

Line 848: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;

844: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
845: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
846:
847: l_mo_org_id oe_order_lines_all.org_id%TYPE;
848: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
849: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
850: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
851: l_loop_count number;
852: l_td_quantity number;

Line 849: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

845: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
846:
847: l_mo_org_id oe_order_lines_all.org_id%TYPE;
848: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
849: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
850: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
851: l_loop_count number;
852: l_td_quantity number;
853: l_uom varchar2(30);

Line 850: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;

846:
847: l_mo_org_id oe_order_lines_all.org_id%TYPE;
848: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
849: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
850: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
851: l_loop_count number;
852: l_td_quantity number;
853: l_uom varchar2(30);
854: l_item_type mtl_system_items.bom_item_type%TYPE;

Line 854: l_item_type mtl_system_items.bom_item_type%TYPE;

850: l_nl_trackable_flag mtl_system_items_b.comms_nl_trackable_flag%TYPE;
851: l_loop_count number;
852: l_td_quantity number;
853: l_uom varchar2(30);
854: l_item_type mtl_system_items.bom_item_type%TYPE;
855: l_location_type_code varchar2(30) := fnd_api.g_miss_char;
856: l_location_id number := fnd_api.g_miss_num;
857: l_operating_unit_id number;
858: l_oa_relationship_code varchar2(30);

Line 890: FROM mtl_system_items_kfv

886: l_lot_control_code,
887: l_nl_trackable_flag,
888: l_txn_source_rec.primary_uom,
889: l_shippable_flag
890: FROM mtl_system_items_kfv
891: WHERE inventory_item_id = l_txn_source_rec.inventory_item_id
892: AND organization_id = l_txn_source_rec.organization_id;
893:
894: EXCEPTION