DBA Data[Home] [Help]

APPS.CSI_II_RELATIONSHIPS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 3128: ,mtl_system_items_b msi

3124: BEGIN
3125: SELECT msi.ib_item_instance_class
3126: INTO l_link
3127: FROM csi_item_instances cii
3128: ,mtl_system_items_b msi
3129: WHERE cii.instance_id = p_instance_id
3130: AND msi.inventory_item_id=cii.inventory_item_id
3131: AND msi.organization_id=cii.last_vld_organization_id
3132: AND msi.ib_item_instance_class = l_class;

Line 5599: from MTL_SYSTEM_ITEMS_B

5595: -- items to be transacted with the serial number. Hence other locations are not considered.
5596: Begin
5597: select serial_number_control_code
5598: into l_srl_ctl
5599: from MTL_SYSTEM_ITEMS_B
5600: where inventory_item_id = l_item_id
5601: and organization_id = l_vld_org;
5602: --
5603: IF l_srl_ctl = 6 THEN

Line 6198: from MTL_SYSTEM_ITEMS_B

6194: -- items to be transacted with the serial number. Hence other locations are not considered.
6195: Begin
6196: select serial_number_control_code
6197: into l_srl_ctl
6198: from MTL_SYSTEM_ITEMS_B
6199: where inventory_item_id = l_item_id
6200: and organization_id = l_vld_org;
6201: --
6202: IF l_srl_ctl = 6 THEN

Line 6706: FROM mtl_system_items

6702: ,l_bom_item_type
6703: ,l_pick_comp_flag
6704: ,l_base_item_id
6705: ,l_repl_order_flag
6706: FROM mtl_system_items
6707: WHERE inventory_item_id = l_inventory_item_id
6708: AND organization_id = l_vld_org_id ;
6709: -- Item is under serial control but serial_number is NULL
6710: -- '1' stands for - No serial number control

Line 6804: FROM mtl_system_items

6800: ,l_bom_item_type
6801: ,l_pick_comp_flag
6802: ,l_base_item_id -- fix for bug 2304221
6803: ,l_repl_order_flag
6804: FROM mtl_system_items
6805: WHERE inventory_item_id = l_inventory_item_id
6806: AND organization_id = l_vld_org_id ;
6807: -- Item is under serial control but serial_number is NULL
6808: -- '1' stands for - No serial number control