DBA Data[Home] [Help]

APPS.CSI_INTERFACE_PKG dependencies on ALL_TAB_COLUMNS

Line 638: -- Hence used a Dynamic sal based on the existance of this column in ALL_TAB_COLUMNS.

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);
642:

Line 653: from all_tab_columns

649:
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;

Line 683: from all_tab_columns

679: -- for config_model_type
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;