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.EGO_IMPORT_PVT dependencies on MTL_CROSS_REFERENCES

Line 5042: FROM MTL_SYSTEM_ITEMS_INTERFACE intf, MTL_PARAMETERS p, MTL_CROSS_REFERENCES c

5038: intf.TRANSACTION_ID,
5039: c.CROSS_REFERENCE EXISTING_GTIN,
5040: c.DESCRIPTION EXISTING_GTIN_DESC,
5041: c.CROSS_REFERENCE_ID
5042: FROM MTL_SYSTEM_ITEMS_INTERFACE intf, MTL_PARAMETERS p, MTL_CROSS_REFERENCES c
5043: WHERE intf.SET_PROCESS_ID = p_data_set_id
5044: AND intf.ORGANIZATION_ID = p.ORGANIZATION_ID
5045: AND p.ORGANIZATION_ID = p.MASTER_ORGANIZATION_ID
5046: AND intf.PROCESS_FLAG IN (5,7)

Line 5281: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_CROSS_REFERENCES_B mcr, MTL_PARAMETERS mp

5277: -- checking for duplicate GTIN
5278: IF NOT l_error THEN
5279: BEGIN
5280: SELECT CONCATENATED_SEGMENTS INTO l_existing_gtin
5281: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_CROSS_REFERENCES_B mcr, MTL_PARAMETERS mp
5282: WHERE msik.INVENTORY_ITEM_ID = mcr.INVENTORY_ITEM_ID
5283: AND msik.ORGANIZATION_ID = mp.ORGANIZATION_ID
5284: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
5285: AND mcr.CROSS_REFERENCE_TYPE = 'GTIN'

Line 5317: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(

5313: END IF; -- checking for duplicate GTIN
5314: -- if no errors then creating a GTIN
5315: IF NOT l_error THEN
5316: Debug_Conc_Log('No Errors - Creating GTIN');
5317: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(
5318: P_SOURCE_SYSTEM_ID => NULL,
5319: P_START_DATE_ACTIVE => NULL,
5320: P_END_DATE_ACTIVE => NULL,
5321: P_OBJECT_VERSION_NUMBER => NULL,

Line 5370: UPDATE MTL_CROSS_REFERENCES_TL

5366: OR (i.EXISTING_GTIN_DESC IS NULL AND i.GTIN_DESCRIPTION IS NOT NULL)
5367: )
5368: THEN
5369: Debug_Conc_Log('Existing GTIN found. Description needs to be updated.');
5370: UPDATE MTL_CROSS_REFERENCES_TL
5371: SET DESCRIPTION = i.GTIN_DESCRIPTION,
5372: LAST_UPDATE_DATE = SYSDATE,
5373: LAST_UPDATED_BY = l_user_id,
5374: LAST_UPDATE_LOGIN = l_login_id,

Line 5476: FROM MTL_CROSS_REFERENCES_B mcr

5472: l_raise_event := FALSE;
5473: -- if a cross reference already exists for the source system item, then end dating it
5474: BEGIN
5475: SELECT ROWID, INVENTORY_ITEM_ID INTO l_rowid, l_item_id
5476: FROM MTL_CROSS_REFERENCES_B mcr
5477: WHERE mcr.SOURCE_SYSTEM_ID = p_source_system_id
5478: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
5479: AND mcr.CROSS_REFERENCE = p_source_system_reference
5480: AND (mcr.END_DATE_ACTIVE IS NULL OR mcr.END_DATE_ACTIVE > SYSDATE);

Line 5485: UPDATE MTL_CROSS_REFERENCES_B

5481:
5482: Debug_Conc_Log('Existing Xref found l_item_id='||to_char(l_item_id));
5483: IF p_inventory_item_id <> NVL(l_item_id, -1) THEN
5484: Debug_Conc_Log('Updating the existing SS Xref, end dating');
5485: UPDATE MTL_CROSS_REFERENCES_B
5486: SET
5487: END_DATE_ACTIVE = SYSDATE,
5488: LAST_UPDATED_BY = l_user_id,
5489: LAST_UPDATE_DATE = SYSDATE,

Line 5506: -- calling MTL_CROSS_REFERENCES_B table handler to insert rows

5502: NULL;
5503: END;
5504:
5505: IF p_inventory_item_id <> NVL(l_item_id, -1) THEN
5506: -- calling MTL_CROSS_REFERENCES_B table handler to insert rows
5507: Debug_Conc_Log('Creating SS Xref');
5508: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(
5509: P_SOURCE_SYSTEM_ID => p_source_system_id,
5510: P_START_DATE_ACTIVE => SYSDATE,

Line 5508: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(

5504:
5505: IF p_inventory_item_id <> NVL(l_item_id, -1) THEN
5506: -- calling MTL_CROSS_REFERENCES_B table handler to insert rows
5507: Debug_Conc_Log('Creating SS Xref');
5508: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(
5509: P_SOURCE_SYSTEM_ID => p_source_system_id,
5510: P_START_DATE_ACTIVE => SYSDATE,
5511: P_END_DATE_ACTIVE => NULL,
5512: P_OBJECT_VERSION_NUMBER => NULL,

Line 5577: FROM MTL_CROSS_REFERENCES_B mcr

5573: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5574: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL
5575: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
5576: AND NOT EXISTS (SELECT NULL
5577: FROM MTL_CROSS_REFERENCES_B mcr
5578: WHERE mcr.SOURCE_SYSTEM_ID = msi.SOURCE_SYSTEM_ID
5579: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
5580: AND mcr.CROSS_REFERENCE = msi.SOURCE_SYSTEM_REFERENCE
5581: AND mcr.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID

Line 5595: FROM MTL_SYSTEM_ITEMS_INTERFACE msi, MTL_CROSS_REFERENCES mcr

5591: msi.ORGANIZATION_ID,
5592: msi.TRANSACTION_ID,
5593: msi.TRANSACTION_TYPE,
5594: mcr.CROSS_REFERENCE_ID
5595: FROM MTL_SYSTEM_ITEMS_INTERFACE msi, MTL_CROSS_REFERENCES mcr
5596: WHERE msi.PROCESS_FLAG IN (5, 7)
5597: AND msi.SET_PROCESS_ID = p_data_set_id
5598: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5599: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL

Line 5631: FROM MTL_CROSS_REFERENCES_B mcr

5627: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5628: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL
5629: AND msi.CONFIRM_STATUS IN ('CM', 'CC')
5630: AND NOT EXISTS (SELECT NULL
5631: FROM MTL_CROSS_REFERENCES_B mcr
5632: WHERE mcr.SOURCE_SYSTEM_ID = msi.SOURCE_SYSTEM_ID
5633: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
5634: AND mcr.CROSS_REFERENCE = msi.SOURCE_SYSTEM_REFERENCE
5635: AND mcr.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID

Line 5651: FROM MTL_SYSTEM_ITEMS_INTERFACE msi, MTL_CROSS_REFERENCES mcr

5647: msi.TRANSACTION_ID,
5648: msi.TRANSACTION_TYPE,
5649: mcr.CROSS_REFERENCE_ID,
5650: msi.ROWID AS ROW_ID
5651: FROM MTL_SYSTEM_ITEMS_INTERFACE msi, MTL_CROSS_REFERENCES mcr
5652: WHERE msi.PROCESS_FLAG IN (0, 11)
5653: AND msi.SET_PROCESS_ID = p_data_set_id
5654: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5655: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL

Line 5714: UPDATE MTL_CROSS_REFERENCES_TL

5710: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5711: l_inventory_item_id := i.INVENTORY_ITEM_ID;
5712:
5713: IF l_inventory_item_id IS NOT NULL THEN
5714: UPDATE MTL_CROSS_REFERENCES_TL
5715: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5716: LAST_UPDATE_DATE = SYSDATE,
5717: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5718: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 5839: UPDATE MTL_CROSS_REFERENCES_TL

5835: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5836: l_inventory_item_id := i.INVENTORY_ITEM_ID;
5837:
5838: IF l_inventory_item_id IS NOT NULL THEN
5839: UPDATE MTL_CROSS_REFERENCES_TL
5840: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5841: LAST_UPDATE_DATE = SYSDATE,
5842: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5843: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 7242: FROM MTL_CROSS_REFERENCES_B XREF

7238: MTL_SYSTEM_ITEMS_INTERFACE MSII
7239: SET TRANSACTION_TYPE = UPPER( TRANSACTION_TYPE )
7240: , INVENTORY_ITEM_ID =
7241: (SELECT INVENTORY_ITEM_ID
7242: FROM MTL_CROSS_REFERENCES_B XREF
7243: WHERE XREF.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF' AND
7244: XREF.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE AND
7245: XREF.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID AND
7246: SYSDATE BETWEEN NVL(XREF.START_DATE_ACTIVE, SYSDATE - 1) AND NVL(XREF.END_DATE_ACTIVE, SYSDATE + 1) AND #'

Line 7898: MTL_CROSS_REFERENCES MCR

7894: MSII.ORGANIZATION_ID,
7895: MSII.TRANSACTION_ID
7896: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,
7897: MTL_SYSTEM_ITEMS_INTERFACE MSII,
7898: MTL_CROSS_REFERENCES MCR
7899: WHERE MSII.SET_PROCESS_ID = p_data_set_id
7900: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
7901: AND MSII.SOURCE_SYSTEM_ID = MCR.SOURCE_SYSTEM_ID
7902: AND MSII.ORGANIZATION_ID = KFV.ORGANIZATION_ID

Line 8056: FROM MTL_CROSS_REFERENCES_VL APPLYSEC

8052: AND ORGANIZATION_ID = :org_id
8053: AND CONFIRM_STATUS IN ('CC', 'CM', 'CFC', 'CFM')
8054: AND EXISTS
8055: (SELECT 1
8056: FROM MTL_CROSS_REFERENCES_VL APPLYSEC
8057: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8058: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8059: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8060: AND APPLYSEC.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID

Line 8080: FROM MTL_CROSS_REFERENCES_B APPLYSEC

8076: AND PROCESS_FLAG = 0
8077: AND ORGANIZATION_ID = :org_id
8078: AND CONFIRM_STATUS IN ('CC', 'CM', 'CFC', 'CFM')
8079: AND EXISTS ( SELECT 1
8080: FROM MTL_CROSS_REFERENCES_B APPLYSEC
8081: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8082: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8083: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8084: AND APPLYSEC.INVENTORY_ITEM_ID <> MSII.INVENTORY_ITEM_ID

Line 8104: FROM MTL_CROSS_REFERENCES_B XREF

8100: AND NOT #' || l_security_predicate || q'#
8101: AND APPLYSEC.INVENTORY_ITEM_ID IS NOT NULL
8102: AND LNNVL (APPLYSEC.INVENTORY_ITEM_ID =
8103: (SELECT XREF.INVENTORY_ITEM_ID
8104: FROM MTL_CROSS_REFERENCES_B XREF
8105: WHERE XREF.CROSS_REFERENCE = APPLYSEC.SOURCE_SYSTEM_REFERENCE
8106: AND XREF.SOURCE_SYSTEM_ID = APPLYSEC.SOURCE_SYSTEM_ID
8107: AND XREF.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8108: AND SYSDATE BETWEEN NVL(XREF.START_DATE_ACTIVE, SYSDATE-1) AND NVL(XREF.END_DATE_ACTIVE, SYSDATE + 1))) #';

Line 8363: AND EXISTS ( SELECT 1 FROM MTL_CROSS_REFERENCES_B APPLYSEC

8359: WHERE SET_PROCESS_ID = :p_data_set_id
8360: AND PROCESS_FLAG = 0
8361: AND ORGANIZATION_ID = :org_id
8362: AND CONFIRM_status = 'CNR'
8363: AND EXISTS ( SELECT 1 FROM MTL_CROSS_REFERENCES_B APPLYSEC
8364: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8365: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8366: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8367: AND SYSDATE BETWEEN NVL(APPLYSEC.START_DATE_ACTIVE, SYSDATE-1) AND NVL(APPLYSEC.END_DATE_ACTIVE, SYSDATE + 1)

Line 8384: FROM MTL_CROSS_REFERENCES_VL APPLYSEC

8380: AND ORGANIZATION_ID = :org_id
8381: AND CONFIRM_STATUS IN ('CCR', 'CMR', 'FMR' )
8382: AND EXISTS
8383: (SELECT 1
8384: FROM MTL_CROSS_REFERENCES_VL APPLYSEC
8385: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8386: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8387: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8388: AND APPLYSEC.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID

Line 8408: FROM MTL_CROSS_REFERENCES_B APPLYSEC

8404: AND PROCESS_FLAG = 0
8405: AND ORGANIZATION_ID = :org_id
8406: AND CONFIRM_STATUS IN ( 'CCR', 'CMR', 'FMR' )
8407: AND EXISTS ( SELECT 1
8408: FROM MTL_CROSS_REFERENCES_B APPLYSEC
8409: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8410: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8411: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8412: AND APPLYSEC.INVENTORY_ITEM_ID <> MSII.INVENTORY_ITEM_ID

Line 8433: FROM MTL_CROSS_REFERENCES_B XREF

8429: AND NOT #' || l_security_predicate || q'#
8430: AND APPLYSEC.INVENTORY_ITEM_ID IS NOT NULL
8431: AND LNNVL (APPLYSEC.INVENTORY_ITEM_ID =
8432: (SELECT XREF.INVENTORY_ITEM_ID
8433: FROM MTL_CROSS_REFERENCES_B XREF
8434: WHERE XREF.CROSS_REFERENCE = APPLYSEC.SOURCE_SYSTEM_REFERENCE
8435: AND XREF.SOURCE_SYSTEM_ID = APPLYSEC.SOURCE_SYSTEM_ID
8436: AND XREF.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8437: AND SYSDATE BETWEEN NVL(XREF.START_DATE_ACTIVE, SYSDATE-1) AND NVL(XREF.END_DATE_ACTIVE, SYSDATE + 1))) #';

Line 8924: FROM MTL_CROSS_REFERENCES_B MCR

8920: (SELECT
8921: 1,
8922: NVL(MSII.TRANSACTION_TYPE, 'SYNC'),
8923: MCR.INVENTORY_ITEM_ID
8924: FROM MTL_CROSS_REFERENCES_B MCR
8925: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8926: AND MCR.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8927: AND MCR.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8928: AND SYSDATE BETWEEN NVL(MCR.START_DATE_ACTIVE, SYSDATE - 1) AND NVL(MCR.END_DATE_ACTIVE, SYSDATE + 1)

Line 8950: FROM MTL_CROSS_REFERENCES_B MCR

8946: AND MSII2.ORGANIZATION_ID = :l_org_id1
8947: )
8948: -- HAS A CROSS REFERENCE
8949: AND EXISTS (SELECT NULL
8950: FROM MTL_CROSS_REFERENCES_B MCR
8951: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8952: AND MCR.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8953: AND MCR.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8954: AND SYSDATE BETWEEN NVL(MCR.START_DATE_ACTIVE, SYSDATE - 1) AND NVL(MCR.END_DATE_ACTIVE, SYSDATE + 1)

Line 8969: FROM MTL_CROSS_REFERENCES_B MCR

8965: (SELECT
8966: 1,
8967: NVL(MIRI.TRANSACTION_TYPE, 'SYNC'),
8968: MCR.INVENTORY_ITEM_ID
8969: FROM MTL_CROSS_REFERENCES_B MCR
8970: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8971: AND MCR.CROSS_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
8972: AND MCR.SOURCE_SYSTEM_ID = MIRI.SOURCE_SYSTEM_ID
8973: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 8990: FROM MTL_CROSS_REFERENCES_B MCR

8986: AND MSII.ORGANIZATION_ID = :l_org_id
8987: )
8988: -- HAS A CROSS REFERENCE
8989: AND EXISTS (SELECT NULL
8990: FROM MTL_CROSS_REFERENCES_B MCR
8991: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8992: AND MCR.CROSS_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
8993: AND MCR.SOURCE_SYSTEM_ID = MIRI.SOURCE_SYSTEM_ID
8994: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9026: FROM MTL_CROSS_REFERENCES_B MCR

9022: AND MSII.ORGANIZATION_ID = :l_org_id
9023: )
9024: -- HAS A CROSS REFERENCE
9025: AND EXISTS (SELECT NULL
9026: FROM MTL_CROSS_REFERENCES_B MCR
9027: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9028: AND MCR.CROSS_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
9029: AND MCR.SOURCE_SYSTEM_ID = MIRI.SOURCE_SYSTEM_ID
9030: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9047: FROM MTL_CROSS_REFERENCES_B MCR

9043: (SELECT
9044: 1,
9045: MICI.TRANSACTION_TYPE,
9046: MCR.INVENTORY_ITEM_ID
9047: FROM MTL_CROSS_REFERENCES_B MCR
9048: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9049: AND MCR.CROSS_REFERENCE = MICI.SOURCE_SYSTEM_REFERENCE
9050: AND MCR.SOURCE_SYSTEM_ID = MICI.SOURCE_SYSTEM_ID
9051: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9068: FROM MTL_CROSS_REFERENCES_B MCR

9064: AND MSII.ORGANIZATION_ID = :l_org_id
9065: )
9066: -- HAS A CROSS REFERENCE
9067: AND EXISTS (SELECT NULL
9068: FROM MTL_CROSS_REFERENCES_B MCR
9069: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9070: AND MCR.CROSS_REFERENCE = MICI.SOURCE_SYSTEM_REFERENCE
9071: AND MCR.SOURCE_SYSTEM_ID = MICI.SOURCE_SYSTEM_ID
9072: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9088: FROM MTL_CROSS_REFERENCES_B MCR

9084: (SELECT
9085: 1,
9086: NVL(EIPI.TRANSACTION_TYPE, 'SYNC'),
9087: MCR.INVENTORY_ITEM_ID
9088: FROM MTL_CROSS_REFERENCES_B MCR
9089: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9090: AND MCR.CROSS_REFERENCE = EIPI.SOURCE_SYSTEM_REFERENCE
9091: AND MCR.SOURCE_SYSTEM_ID = EIPI.SOURCE_SYSTEM_ID
9092: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9109: FROM MTL_CROSS_REFERENCES_B MCR

9105: AND MSII.ORGANIZATION_ID = :l_org_id
9106: )
9107: -- HAS A CROSS REFERENCE
9108: AND EXISTS (SELECT NULL
9109: FROM MTL_CROSS_REFERENCES_B MCR
9110: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9111: AND MCR.CROSS_REFERENCE = EIPI.SOURCE_SYSTEM_REFERENCE
9112: AND MCR.SOURCE_SYSTEM_ID = EIPI.SOURCE_SYSTEM_ID
9113: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9129: FROM MTL_CROSS_REFERENCES_B MCR

9125: (SELECT
9126: 1,
9127: NVL(EIUAI.TRANSACTION_TYPE, 'SYNC'),
9128: MCR.INVENTORY_ITEM_ID
9129: FROM MTL_CROSS_REFERENCES_B MCR
9130: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9131: AND MCR.CROSS_REFERENCE = EIUAI.SOURCE_SYSTEM_REFERENCE
9132: AND MCR.SOURCE_SYSTEM_ID = EIUAI.SOURCE_SYSTEM_ID
9133: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9150: FROM MTL_CROSS_REFERENCES_B MCR

9146: AND MSII.ORGANIZATION_ID = :l_org_id
9147: )
9148: -- HAS A CROSS REFERENCE
9149: AND EXISTS (SELECT NULL
9150: FROM MTL_CROSS_REFERENCES_B MCR
9151: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9152: AND MCR.CROSS_REFERENCE = EIUAI.SOURCE_SYSTEM_REFERENCE
9153: AND MCR.SOURCE_SYSTEM_ID = EIUAI.SOURCE_SYSTEM_ID
9154: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9170: FROM MTL_CROSS_REFERENCES_B MCR

9166: (SELECT
9167: 1,
9168: NVL(EAI.TRANSACTION_TYPE, 'SYNC'),
9169: MCR.INVENTORY_ITEM_ID
9170: FROM MTL_CROSS_REFERENCES_B MCR
9171: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9172: AND MCR.CROSS_REFERENCE = EAI.SOURCE_SYSTEM_REFERENCE
9173: AND MCR.SOURCE_SYSTEM_ID = EAI.SOURCE_SYSTEM_ID
9174: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9191: FROM MTL_CROSS_REFERENCES_B MCR

9187: AND MSII.ORGANIZATION_ID = :l_org_id
9188: )
9189: -- HAS A CROSS REFERENCE
9190: AND EXISTS (SELECT NULL
9191: FROM MTL_CROSS_REFERENCES_B MCR
9192: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9193: AND MCR.CROSS_REFERENCE = EAI.SOURCE_SYSTEM_REFERENCE
9194: AND MCR.SOURCE_SYSTEM_ID = EAI.SOURCE_SYSTEM_ID
9195: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9211: FROM MTL_CROSS_REFERENCES_B MCR

9207: (SELECT
9208: 1,
9209: EIAI.TRANSACTION_TYPE,
9210: MCR.INVENTORY_ITEM_ID
9211: FROM MTL_CROSS_REFERENCES_B MCR
9212: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9213: AND MCR.CROSS_REFERENCE = EIAI.SOURCE_SYSTEM_REFERENCE
9214: AND MCR.SOURCE_SYSTEM_ID = EIAI.SOURCE_SYSTEM_ID
9215: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9232: FROM MTL_CROSS_REFERENCES_B MCR

9228: AND MSII.ORGANIZATION_ID = :l_org_id
9229: )
9230: -- HAS A CROSS REFERENCE
9231: AND EXISTS (SELECT NULL
9232: FROM MTL_CROSS_REFERENCES_B MCR
9233: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9234: AND MCR.CROSS_REFERENCE = EIAI.SOURCE_SYSTEM_REFERENCE
9235: AND MCR.SOURCE_SYSTEM_ID = EIAI.SOURCE_SYSTEM_ID
9236: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9433: l_xref_desc MTL_CROSS_REFERENCES.DESCRIPTION%TYPE;

9429: l_priv_exists VARCHAR2(1);
9430: l_msg_text VARCHAR2(4000);
9431: l_xref_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
9432: l_xref_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
9433: l_xref_desc MTL_CROSS_REFERENCES.DESCRIPTION%TYPE;
9434: l_org_code MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_CODE%TYPE;
9435: l_party_name VARCHAR2(1000); -- Bug: 5355759
9436: BEGIN
9437: x_return_code := 0;

Line 9802: FROM MTL_CROSS_REFERENCES MCR,

9798: , MCR.DESCRIPTION
9799: INTO l_xref_item_number
9800: , l_xref_item_id
9801: , l_xref_desc
9802: FROM MTL_CROSS_REFERENCES MCR,
9803: MTL_SYSTEM_ITEMS_KFV MSIK
9804: WHERE MCR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
9805: AND MSIK.ORGANIZATION_ID = l_org_id
9806: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'