APPS.CSI_INTERFACE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 132: FROM mtl_system_items msi

128: p_org_id => l_org_id);
129:
130: SELECT nvl(msi.comms_nl_trackable_flag, 'N')
131: INTO l_ib_trackable_flag
132: FROM mtl_system_items msi
133: WHERE msi.inventory_item_id = l_inventory_item_id
134: AND msi.organization_id = l_organization_id;
135:
136: IF l_ib_trackable_flag = 'Y' THEN

Line 337: FROM mtl_system_items msi

333: p_org_id => l_line_tbl(l_ind).org_id);
334:
335: SELECT nvl(msi.comms_nl_trackable_flag,'N')
336: INTO l_ib_trackable_flag
337: FROM mtl_system_items msi
338: WHERE msi.inventory_item_id = l_line_tbl(l_ind).inventory_item_id
339: AND msi.organization_id = l_organization_id;
340:
341: /* if trackable populate it for the final out table */

Line 632: FROM mtl_system_items

628: x_item_attrib_rec.bom_item_type,
629: x_item_attrib_rec.pick_components_flag,
630: x_item_attrib_rec.model_item_id,
631: x_item_attrib_rec.primary_uom_code
632: FROM mtl_system_items
633: WHERE inventory_item_id = p_inventory_item_id
634: AND organization_id = p_organization_id;
635:
636: -- get org attributes aswell

Line 637: -- Ib_item_instance_class column may or may not exists in mtl_system_items_b.

633: WHERE inventory_item_id = p_inventory_item_id
634: AND organization_id = p_organization_id;
635:
636: -- get org attributes aswell
637: -- Ib_item_instance_class column may or may not exists in mtl_system_items_b.
638: -- Hence used a Dynamic sal based on the existance of this column in ALL_TAB_COLUMNS.
639:
640: -- For Bug 3431768
641: l_return := FND_INSTALLATION.get_app_info('INV',l_status,l_industry,l_oracle_schema);

Line 654: where table_name = 'MTL_SYSTEM_ITEMS_B'

650: Begin
651: select 'X'
652: into l_exists
653: from all_tab_columns
654: where table_name = 'MTL_SYSTEM_ITEMS_B'
655: and column_name = 'IB_ITEM_INSTANCE_CLASS'
656: and OWNER = l_oracle_schema
657: and rownum < 2;
658: Exception

Line 662: l_sql_stmt := 'select ib_item_instance_class from MTL_SYSTEM_ITEMS_B '||

658: Exception
659: when no_data_found then
660: l_exists := 'N';
661: End;
662: l_sql_stmt := 'select ib_item_instance_class from MTL_SYSTEM_ITEMS_B '||
663: 'where inventory_item_id = :item_id '||
664: 'and organization_id = :vld_org_id';
665: --
666: IF l_exists = 'X' THEN

Line 684: where table_name = 'MTL_SYSTEM_ITEMS_B'

680: Begin
681: select 'X'
682: into l_exists
683: from all_tab_columns
684: where table_name = 'MTL_SYSTEM_ITEMS_B'
685: and column_name = 'CONFIG_MODEL_TYPE'
686: and OWNER = l_oracle_schema
687: and rownum < 2;
688: Exception

Line 692: l_sql_stmt := 'select config_model_type from MTL_SYSTEM_ITEMS_B '||

688: Exception
689: when no_data_found then
690: l_exists := 'N';
691: End;
692: l_sql_stmt := 'select config_model_type from MTL_SYSTEM_ITEMS_B '||
693: 'where inventory_item_id = :item_id '||
694: 'and organization_id = :vld_org_id';
695: --
696: IF l_exists = 'X' THEN

Line 5045: FROM mtl_system_items msi,

5041: msi.primary_uom_code primary_uom,
5042: abs(mmt.primary_quantity) primary_quantity,
5043: mmt.transaction_type_id transaction_type_id,
5044: mmt.transaction_action_id transaction_action_id
5045: FROM mtl_system_items msi,
5046: mtl_unit_transactions mut,
5047: mtl_material_transactions mmt
5048: WHERE mmt.transaction_id = p_txn_id
5049: AND mmt.transaction_id = mut.transaction_id(+)

Line 5071: FROM mtl_system_items msi,

5067: msi.primary_uom_code primary_uom,
5068: abs(mtln.primary_quantity) primary_quantity,
5069: mmt.transaction_type_id transaction_type_id,
5070: mmt.transaction_action_id transaction_action_id
5071: FROM mtl_system_items msi,
5072: mtl_unit_transactions mut,
5073: mtl_transaction_lot_numbers mtln,
5074: mtl_material_transactions mmt
5075: WHERE mmt.transaction_id = p_txn_id