[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
EXECUTE IMMEDIATE 'SELECT IR.REVISION FROM MTL_ITEM_REVISIONS_B IR
WHERE IR.INVENTORY_ITEM_ID = :1
AND IR.ORGANIZATION_ID = :2
AND IR.REVISION_ID IN
(SELECT MAX(IR2.REVISION_ID)
KEEP (DENSE_RANK LAST ORDER BY IR2.EFFECTIVITY_DATE )
FROM MTL_ITEM_REVISIONS_B IR2
WHERE IR2.ORGANIZATION_ID = IR.ORGANIZATION_ID
AND IR2.INVENTORY_ITEM_ID = IR.INVENTORY_ITEM_ID
AND IR2.EFFECTIVITY_DATE <= SYSDATE
AND IR2.IMPLEMENTATION_DATE IS NOT NULL
)' INTO l_rev USING p_inventory_item_id, p_organization_id;
EXECUTE IMMEDIATE 'SELECT REVISION
FROM MTL_ITEM_REVISIONS
WHERE INVENTORY_ITEM_ID = :1
AND ORGANIZATION_ID = :2
AND REVISION = :3' INTO l_temp USING p_inventory_item_id, p_organization_id, p_revision;
SELECT FUNCTION_NAME INTO l_name
FROM FND_FORM_FUNCTIONS
WHERE FUNCTION_ID = p_priv_id;
SELECT
AG.ATTR_GROUP_NAME,
AG.ATTR_GROUP_DISP_NAME,
AG.VIEW_PRIVILEGE_ID,
A.ATTR_ID,
A.DATABASE_COLUMN,
A.ATTR_DISPLAY_NAME ,
A.VALIDATION_CODE,
A.ATTR_NAME,
A.VALUE_SET_ID,
A.DATA_TYPE_CODE,
A.UOM_CLASS
FROM
EGO_ATTR_GROUPS_DL_V AG ,
EGO_ATTRS_V A
WHERE A.ATTR_GROUP_TYPE = AG.ATTR_GROUP_TYPE
AND A.ATTR_GROUP_TYPE = 'EGO_MASTER_ITEMS'
AND A.ATTR_GROUP_NAME = AG.ATTR_GROUP_NAME
AND A.APPLICATION_ID = AG.APPLICATION_ID
AND A.APPLICATION_ID = 431
AND AG.ATTR_GROUP_NAME <> 'Main'
ORDER BY AG.ATTR_GROUP_NAME;
SELECT
AG.ATTR_GROUP_ID,
AG.ATTR_GROUP_NAME
FROM EGO_ATTR_GROUPS_DL_V AG
WHERE AG.ATTR_GROUP_TYPE IN ('EGO_MASTER_ITEMS')
AND AG.ATTR_GROUP_NAME <> 'Main'
AND AG.APPLICATION_ID = 431 ;
SELECT
LOOKUP_CODE,
MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE ='EGO_ITEM_PRIMARY_ATTRIBUTE_GRP'
AND LOOKUP_CODE NOT IN ('APPROVAL_STATUS','ITEM_NUMBER', 'NEW_ITEM_REQUEST') -- 'LONG_DESCRIPTION',
AND ENABLED_FLAG = 'Y'
AND (NVL(START_DATE_ACTIVE, SYSDATE - 1) < SYSDATE)
AND (NVL(END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE);
SELECT DISTINCT
I.ATTR_GROUP_INT_NAME,
I.REVISION,
AG.DATA_LEVEL_INTERNAL_NAME, -- R12C: Added
AG.DATA_LEVEL_ID, -- R12C: Added
AG.ATTR_GROUP_DISP_NAME,
AG.ATTR_GROUP_ID,
AG.VIEW_PRIVILEGE_ID
FROM
EGO_ITM_USR_ATTR_INTRFC I,
EGO_ATTR_GROUPS_DL_V AG
WHERE NVL(AG.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP') = 'EGO_ITEMMGMT_GROUP'
AND I.SOURCE_SYSTEM_ID = p_ss_code
AND I.SOURCE_SYSTEM_REFERENCE = p_ss_record
AND I.DATA_SET_ID = p_batch_id
AND NVL(I.PROCESS_STATUS, -1) < 1
AND (REVISION IS NULL OR REVISION = c_revision)
AND I.organization_id = p_org_id
AND I.ATTR_GROUP_INT_NAME = AG.ATTR_GROUP_NAME
AND ( I.DATA_LEVEL_ID = AG.DATA_LEVEL_ID
OR I.DATA_LEVEL_NAME = AG.DATA_LEVEL_INTERNAL_NAME )
AND AG.APPLICATION_ID = 431
AND AG.MULTI_ROW_CODE = 'N'
AND ( I.BUNDLE_ID IS NULL OR I.BUNDLE_ID = c_bundle_id );
SELECT
AV.ATTR_ID,
AGV.ATTR_GROUP_ID,
I.ATTR_VALUE_STR,
I.ATTR_VALUE_NUM,
I.ATTR_VALUE_DATE,
I.ATTR_DISP_VALUE,
I.REVISION_ID,
I.REVISION,
I.ATTR_VALUE_UOM,
I.ATTR_UOM_DISP_VALUE,
AV.ATTR_DISPLAY_NAME,
AGV.ATTR_GROUP_DISP_NAME,
I.ATTR_INT_NAME ,
I.ATTR_GROUP_INT_NAME,
AGV.DATA_LEVEL_ID, -- R12C: Added
AGV.DATA_LEVEL_INTERNAL_NAME, -- R12C: Added
AV.DATABASE_COLUMN,
AV.VALUE_SET_ID,
AV.VALIDATION_CODE,
AV.DATA_TYPE_CODE,
AV.UOM_CLASS
FROM
EGO_ITM_USR_ATTR_INTRFC I,
EGO_ATTRS_V AV,
EGO_ATTR_GROUPS_DL_V AGV
WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
AND AV.ATTR_NAME = I.ATTR_INT_NAME
AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME
AND I.ATTR_GROUP_INT_NAME = p_attr_group_int_name
AND I.DATA_LEVEL_ID = p_data_level_id
AND NVL(AGV.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP') = 'EGO_ITEMMGMT_GROUP'
AND I.SOURCE_SYSTEM_ID = p_ss_code
AND I.SOURCE_SYSTEM_REFERENCE = p_ss_record
AND I.DATA_SET_ID = p_batch_id
AND NVL(I.PROCESS_STATUS, -1) < 1
AND I.REVISION IS NULL
AND I.ORGANIZATION_ID = p_org_id
AND ( I.DATA_LEVEL_ID = AGV.DATA_LEVEL_ID
OR I.DATA_LEVEL_NAME = AGV.DATA_LEVEL_INTERNAL_NAME )
AND AV.APPLICATION_ID = 431
AND AGV.APPLICATION_ID = AV.APPLICATION_ID
AND ( I.BUNDLE_ID IS NULL OR I.BUNDLE_ID = c_bundle_id );
SELECT
AV.ATTR_ID,
AGV.ATTR_GROUP_ID,
I.ATTR_VALUE_STR,
I.ATTR_VALUE_NUM,
I.ATTR_VALUE_DATE,
I.ATTR_DISP_VALUE,
I.REVISION_ID,
I.REVISION,
I.ATTR_VALUE_UOM,
I.ATTR_UOM_DISP_VALUE,
AV.ATTR_DISPLAY_NAME,
AV.UOM_CLASS,
AGV.ATTR_GROUP_DISP_NAME,
I.ATTR_INT_NAME ,
I.ATTR_GROUP_INT_NAME,
AGV.DATA_LEVEL_ID, -- R12C: Added
AGV.DATA_LEVEL_INTERNAL_NAME, -- R12C: Added
AV.DATABASE_COLUMN,
AV.VALUE_SET_ID,
AV.VALIDATION_CODE,
AV.DATA_TYPE_CODE
FROM
EGO_ITM_USR_ATTR_INTRFC I,
EGO_ATTRS_V AV,
EGO_ATTR_GROUPS_DL_V AGV
WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
AND AV.ATTR_NAME = I.ATTR_INT_NAME
AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME
AND I.ATTR_GROUP_INT_NAME = p_attr_group_int_name
AND NVL(AGV.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP') = 'EGO_ITEMMGMT_GROUP'
AND I.SOURCE_SYSTEM_ID = p_ss_code
AND I.SOURCE_SYSTEM_REFERENCE = p_ss_record
AND I.DATA_SET_ID = p_batch_id
AND NVL(I.PROCESS_STATUS, -1) < 1
AND I.REVISION = c_revision
AND I.organization_id = p_org_id
AND ( I.DATA_LEVEL_ID = AGV.DATA_LEVEL_ID
OR I.DATA_LEVEL_NAME = AGV.DATA_LEVEL_INTERNAL_NAME )
AND AV.APPLICATION_ID = 431
AND AGV.APPLICATION_ID = AV.APPLICATION_ID
AND ( I.BUNDLE_ID IS NULL OR I.BUNDLE_ID = c_bundle_id );
SELECT
AV.ATTR_ID,
AGV.ATTR_GROUP_ID,
I.ATTR_VALUE_STR,
I.ATTR_VALUE_NUM,
I.ATTR_VALUE_DATE,
I.ATTR_DISP_VALUE,
I.REVISION_ID,
I.ATTR_VALUE_UOM,
I.ATTR_UOM_DISP_VALUE,
AV.ATTR_DISPLAY_NAME,
AGV.ATTR_GROUP_DISP_NAME,
AGV.VIEW_PRIVILEGE_ID,
I.ATTR_INT_NAME ,
I.ATTR_GROUP_INT_NAME,
AV.DATABASE_COLUMN,
AV.VALUE_SET_ID,
AV.VALIDATION_CODE,
AV.DATA_TYPE_CODE,
AV.UOM_CLASS
FROM
EGO_ITM_USR_ATTR_INTRFC I,
EGO_ATTRS_V AV,
EGO_ATTR_GROUPS_DL_V AGV
WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
AND AGV.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_ATTRS'
AND AV.ATTR_NAME = I.ATTR_INT_NAME
AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME
AND I.SOURCE_SYSTEM_ID = p_ss_code
AND I.SOURCE_SYSTEM_REFERENCE = p_ss_record
AND I.DATA_SET_ID = p_batch_id
AND I.organization_id = p_org_id
AND NVL(I.PROCESS_STATUS, -1) < 1
AND AV.APPLICATION_ID = 431
AND AGV.APPLICATION_ID = AV.APPLICATION_ID
AND ( I.BUNDLE_ID IS NULL OR I.BUNDLE_ID = c_bundle_id )
ORDER BY AGV.ATTR_GROUP_ID;
SELECT DISTINCT
I.ATTR_GROUP_INT_NAME,
I.REVISION,
AG.DATA_LEVEL_INTERNAL_NAME, -- R12C: Added
AG.DATA_LEVEL_ID, -- R12C: Added
AG.ATTR_GROUP_DISP_NAME,
AG.ATTR_GROUP_ID,
AG.VIEW_PRIVILEGE_ID
FROM
EGO_ITM_USR_ATTR_INTRFC I,
EGO_ATTR_GROUPS_DL_V AG
WHERE NVL(AG.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP') = 'EGO_ITEMMGMT_GROUP'
AND ((I.INVENTORY_ITEM_ID IS NOT NULL AND I.INVENTORY_ITEM_ID = p_item1)
OR
(I.ITEM_NUMBER IS NOT NULL AND I.ITEM_NUMBER = p_ss_record)
)
AND I.DATA_SET_ID = p_batch_id
AND NVL(I.PROCESS_STATUS, -1) <= 1
AND (REVISION IS NULL OR REVISION = c_revision)
AND I.ORGANIZATION_ID = p_org_id
AND I.ATTR_GROUP_INT_NAME = AG.ATTR_GROUP_name
AND ( I.DATA_LEVEL_ID = AG.DATA_LEVEL_ID
OR I.DATA_LEVEL_NAME = AG.DATA_LEVEL_INTERNAL_NAME )
AND AG.APPLICATION_ID = 431
AND AG.MULTI_ROW_CODE = 'N';
SELECT
AV.ATTR_ID,
AGV.ATTR_GROUP_ID,
I.ATTR_VALUE_STR,
I.ATTR_VALUE_NUM,
I.ATTR_VALUE_DATE,
I.ATTR_DISP_VALUE,
I.REVISION_ID,
I.REVISION,
I.ATTR_VALUE_UOM,
I.ATTR_UOM_DISP_VALUE,
AV.ATTR_DISPLAY_NAME,
AGV.ATTR_GROUP_DISP_NAME,
I.ATTR_INT_NAME ,
I.ATTR_GROUP_INT_NAME,
AGV.DATA_LEVEL_ID, -- R12C: Added
AGV.DATA_LEVEL_INTERNAL_NAME, -- R12C: Added
AV.DATABASE_COLUMN,
AV.VALUE_SET_ID,
AV.VALIDATION_CODE,
AV.DATA_TYPE_CODE,
AV.UOM_CLASS
FROM
EGO_ITM_USR_ATTR_INTRFC I,
EGO_ATTRS_V AV,
EGO_ATTR_GROUPS_DL_V AGV
WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
AND ((I.INVENTORY_ITEM_ID IS NOT NULL AND I.INVENTORY_ITEM_ID = p_item1)
OR
(I.ITEM_NUMBER IS NOT NULL AND I.ITEM_NUMBER = p_ss_record)
)
AND AV.ATTR_NAME = I.ATTR_INT_NAME
AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME
AND I.ATTR_GROUP_INT_NAME = c_attr_group_int_name
AND I.DATA_LEVEL_ID = p_data_level_id
AND NVL(AGV.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP') = 'EGO_ITEMMGMT_GROUP'
AND I.DATA_SET_ID = p_batch_id
AND NVL(I.PROCESS_STATUS, -1) <= 1
AND I.REVISION IS NULL
AND I.ORGANIZATION_ID = p_org_id
AND ( I.DATA_LEVEL_ID = AGV.DATA_LEVEL_ID
OR I.DATA_LEVEL_NAME = AGV.DATA_LEVEL_INTERNAL_NAME )
AND AV.APPLICATION_ID = 431
AND AGV.APPLICATION_ID = AV.APPLICATION_ID;
SELECT
AV.ATTR_ID,
AGV.ATTR_GROUP_ID,
I.ATTR_VALUE_STR,
I.ATTR_VALUE_NUM,
I.ATTR_VALUE_DATE,
I.ATTR_DISP_VALUE,
I.REVISION_ID,
I.REVISION,
I.ATTR_VALUE_UOM,
I.ATTR_UOM_DISP_VALUE,
AV.ATTR_DISPLAY_NAME,
AGV.ATTR_GROUP_DISP_NAME,
I.ATTR_INT_NAME ,
I.ATTR_GROUP_INT_NAME,
AGV.DATA_LEVEL_ID, -- R12C: Added
AGV.DATA_LEVEL_INTERNAL_NAME, -- R12C: Added
AV.DATABASE_COLUMN,
AV.VALUE_SET_ID,
AV.VALIDATION_CODE,
AV.DATA_TYPE_CODE,
AV.UOM_CLASS
FROM
EGO_ITM_USR_ATTR_INTRFC I,
EGO_ATTRS_V AV,
EGO_ATTR_GROUPS_DL_V AGV
WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
AND AV.ATTR_NAME = I.ATTR_INT_NAME
AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME
AND I.ATTR_GROUP_INT_NAME = c_attr_group_int_name
AND NVL(AGV.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP') = 'EGO_ITEMMGMT_GROUP'
AND I.DATA_SET_ID = p_batch_id
AND NVL(I.PROCESS_STATUS, -1) <= 1
AND I.REVISION = c_revision
AND ((I.INVENTORY_ITEM_ID IS NOT NULL AND I.INVENTORY_ITEM_ID = p_item1)
OR
(I.ITEM_NUMBER IS NOT NULL AND I.ITEM_NUMBER = p_ss_record)
)
AND I.ORGANIZATION_ID = p_org_id
AND ( I.DATA_LEVEL_ID = AGV.DATA_LEVEL_ID
OR I.DATA_LEVEL_NAME = AGV.DATA_LEVEL_INTERNAL_NAME )
AND AV.APPLICATION_ID = 431
AND AGV.APPLICATION_ID = AV.APPLICATION_ID;
SELECT
AV.ATTR_ID,
AGV.ATTR_GROUP_ID,
I.ATTR_VALUE_STR,
I.ATTR_VALUE_NUM,
I.ATTR_VALUE_DATE,
I.ATTR_DISP_VALUE,
I.REVISION_ID,
I.ATTR_VALUE_UOM,
I.ATTR_UOM_DISP_VALUE,
AV.ATTR_DISPLAY_NAME,
AGV.ATTR_GROUP_DISP_NAME,
AGV.VIEW_PRIVILEGE_ID,
I.ATTR_INT_NAME ,
I.ATTR_GROUP_INT_NAME,
AV.DATABASE_COLUMN,
AV.VALUE_SET_ID,
AV.VALIDATION_CODE,
AV.DATA_TYPE_CODE,
AV.UOM_CLASS
FROM
EGO_ITM_USR_ATTR_INTRFC I,
EGO_ATTRS_V AV,
EGO_ATTR_GROUPS_DL_V AGV
WHERE AV.ATTR_GROUP_NAME = AGV.ATTR_GROUP_NAME
AND AGV.ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_ATTRS'
AND AV.ATTR_NAME = I.ATTR_INT_NAME
AND AV.ATTR_GROUP_NAME = I.ATTR_GROUP_INT_NAME
AND I.DATA_SET_ID = p_batch_id
AND ((I.INVENTORY_ITEM_ID IS NOT NULL AND I.INVENTORY_ITEM_ID = p_item1)
OR
(I.ITEM_NUMBER IS NOT NULL AND I.ITEM_NUMBER = p_ss_record)
)
AND I.organization_id = p_org_id
AND NVL(I.PROCESS_STATUS, -1) <= 1
AND AV.APPLICATION_ID = 431
AND AGV.APPLICATION_ID = AV.APPLICATION_ID
ORDER BY AGV.ATTR_GROUP_ID;
SELECT
INVENTORY_ITEM_ID,
REVISION_ID,
SOURCE_SYSTEM_REFERENCE
FROM EGO_ITEM_MATCHES
WHERE INVENTORY_ITEM_ID IN (p_item1, p_item2, p_item3, p_item4)
AND SOURCE_SYSTEM_ID = p_ss_code
AND SOURCE_SYSTEM_REFERENCE = p_ss_record
AND BATCH_ID = p_batch_id
AND ORGANIZATION_id = p_org_id;
SELECT party_id INTO l_party_id_num
FROM ego_user_v
WHERE user_id = l_user_id;
SELECT source_system_id INTO l_ss_id
FROM ego_import_batches_b
WHERE batch_id = p_batch_id;
SELECT LIFECYCLE_ID, ITEM_CATALOG_GROUP_ID, CURRENT_PHASE_ID
INTO l_lifecycle_id, l_catalog_id, l_phase_id
FROM MTL_SYSTEM_ITEMS_B
WHERE INVENTORY_ITEM_ID = p_item1
AND ORGANIZATION_ID = p_org_id;
SELECT ic.item_catalog_group_id
INTO l_hier_catalog_id
FROM mtl_item_catalog_groups_b ic
WHERE EXISTS
(SELECT olc.object_classification_code CatalogId
FROM ego_obj_type_lifecycles olc
WHERE olc.object_id = (select object_id from fnd_objects where obj_name = 'EGO_ITEM')
AND olc.lifecycle_id = l_lifecycle_id
AND olc.object_classification_code = ic.item_catalog_group_id
)
AND ROWNUM = 1
CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
START WITH item_catalog_group_id = l_catalog_id;
l_lkup_str :=' SELECT F.MEANING '||
' FROM FND_LOOKUP_VALUES F'||
' WHERE F.LANGUAGE = USERENV(''LANG'')'||
' AND F.LOOKUP_TYPE = ';
l_p_atr_sql('PRIMARY_UOM_CODE') := ' SELECT UOMTL.UNIT_OF_MEASURE_TL '||
' FROM MTL_UNITS_OF_MEASURE_TL UOMTL' ||
' WHERE UOMTL.LANGUAGE = USERENV(''LANG'') ' ||
' AND UOMTL.UOM_CODE = ';
l_p_atr_sql('UOM_CLASS') := ' SELECT UOMTL.UNIT_OF_MEASURE_TL '||
' FROM MTL_UNITS_OF_MEASURE_TL UOMTL' ||
' WHERE UOMTL.LANGUAGE = USERENV(''LANG'') ' ||
' AND UOMTL.BASE_UOM_FLAG = ''Y''' ||
' AND UOMTL.UOM_CLASS = :1 ';
l_p_atr_sql('ITEM_CATALOG_GROUP_ID') := ' SELECT ICGKFV.CONCATENATED_SEGMENTS ' ||
' FROM MTL_ITEM_CATALOG_GROUPS_B_KFV ICGKFV ' ||
' WHERE ICGKFV.ITEM_CATALOG_GROUP_ID = ' ;
l_p_atr_sql('CURRENT_PHASE_ID') := ' SELECT LCP.NAME '||
' FROM PA_EGO_LIFECYCLES_PHASES_V LCP '||
' WHERE LCP.OBJECT_TYPE = ''PA_TASKS'' '||
' AND LCP.PROJ_ELEMENT_ID = ';
l_p_atr_sql('LIFECYCLE_ID') := ' SELECT LC.NAME ' ||
' FROM PA_EGO_LIFECYCLES_PHASES_V LC ' ||
' WHERE LC.OBJECT_TYPE = ''PA_STRUCTURES'''||
' AND LC.PROJ_ELEMENT_ID = ' ;
l_p_atr_sql('LONG_DESCRIPTION') := ' SELECT ITL.LONG_DESCRIPTION '||
' FROM MTL_SYSTEM_ITEMS_TL ITL '||
' WHERE ITL.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID '||
' AND ITL.ORGANIZATION_ID = I.ORGANIZATION_ID '||
' AND ITL.LANGUAGE = USERENV(''LANG'') ';
l_p_atr_sql('DESCRIPTION') := ' SELECT ITL.DESCRIPTION '||
' FROM MTL_SYSTEM_ITEMS_TL ITL '||
' WHERE ITL.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID '||
' AND ITL.ORGANIZATION_ID = I.ORGANIZATION_ID '||
' AND ITL.LANGUAGE = USERENV(''LANG'') ';
l_p_atr_sql('TRADE_ITEM_DESCRIPTOR') := ' SELECT DISPLAY_NAME ' ||
' FROM EGO_VALUE_SET_VALUES_V ' ||
' WHERE VALUE_SET_NAME = ''TradeItemDescVS'' ' ||
' AND INTERNAL_NAME = ';
l_p_atr_sql('STYLE_ITEM_NUMBER') := '( SELECT CONCATENATED_SEGMENTS ' ||
' FROM MTL_SYSTEM_ITEMS_KFV MSIKFV ' ||
' WHERE MSIKFV.INVENTORY_ITEM_ID = I.STYLE_ITEM_ID ' ||
' AND MSIKFV.ORGANIZATION_ID = I.ORGANIZATION_ID '||
') ';
l_p_atr_sql('INVENTORY_ITEM_STATUS_CODE'):= ' SELECT INVENTORY_ITEM_STATUS_CODE_TL ' ||
' FROM mtl_item_status ' ||
' WHERE INVENTORY_ITEM_STATUS_CODE = ' ;
l_msii_sql := 'SELECT INVENTORY_ITEM_ID ';
l_temp_query := 'SELECT VENDOR_NAME FROM PO_VENDORS WHERE VENDOR_ID = :1 ';
l_temp_query := 'SELECT VENDOR_SITE_CODE FROM PO_VENDOR_SITES_ALL WHERE VENDOR_SITE_ID = :1 ';
l_sql_msi := 'SELECT I.INVENTORY_ITEM_ID AS INVENTORY_ITEM_ID ' ;
Debug_Message('Selected Row and started entering into Compare View table for item : ' || TO_CHAR(l_item_id));
Debug_Message('Completed inserting information for primary and operational attributes for all items');
l_sql_query := 'SELECT I.INVENTORY_ITEM_ID ' || l_sel_clause || l_sql_query ||
' AND I.INVENTORY_ITEM_ID = :1'||
' AND I.ORGANIZATION_ID = :2';
l_sql_query := 'SELECT I.INVENTORY_ITEM_ID ' || l_sel_clause || l_sql_query;
l_inv_rev_id_tbl.DELETE ;
Debug_Message('With out Revision - End inserting Attr for Source System for Attr Grp : '||rec_attr.ATTR_GROUP_INT_NAME);
l_sql_query := 'SELECT INVENTORY_ITEM_ID ' || l_sel_clause || l_sql_query ||
' AND I.INVENTORY_ITEM_ID in (:1,:2,:3,:4)'||
' AND I.ORGANIZATION_ID = :5' ;
l_sql_query := 'SELECT INVENTORY_ITEM_ID ' || l_sel_clause || l_sql_query;
l_sql_query := 'SELECT INVENTORY_ITEM_ID '|| l_sel_clause ||
' FROM EGO_ITEM_GTN_ATTRS_VL I ' ||
' WHERE I.INVENTORY_ITEM_ID = :1 ' ||
' AND I.ORGANIZATION_ID = :2 ' ;
l_sql_query := 'SELECT INVENTORY_ITEM_ID '|| l_sel_clause ||
' FROM EGO_ITEM_GTN_ATTRS_VL I ' ||
' WHERE I.INVENTORY_ITEM_ID IN (:1,:2,:3,:4)' ||
' AND I.ORGANIZATION_ID = :5 ' ;