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 5108: FROM MTL_SYSTEM_ITEMS_INTERFACE intf, MTL_PARAMETERS p, MTL_CROSS_REFERENCES c

5104: intf.TRANSACTION_ID,
5105: c.CROSS_REFERENCE EXISTING_GTIN,
5106: c.DESCRIPTION EXISTING_GTIN_DESC,
5107: c.CROSS_REFERENCE_ID
5108: FROM MTL_SYSTEM_ITEMS_INTERFACE intf, MTL_PARAMETERS p, MTL_CROSS_REFERENCES c
5109: WHERE intf.SET_PROCESS_ID = p_data_set_id
5110: AND intf.ORGANIZATION_ID = p.ORGANIZATION_ID
5111: AND p.ORGANIZATION_ID = p.MASTER_ORGANIZATION_ID
5112: AND intf.PROCESS_FLAG IN (5,7)

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

5343: -- checking for duplicate GTIN
5344: IF NOT l_error THEN
5345: BEGIN
5346: SELECT CONCATENATED_SEGMENTS INTO l_existing_gtin
5347: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_CROSS_REFERENCES_B mcr, MTL_PARAMETERS mp
5348: WHERE msik.INVENTORY_ITEM_ID = mcr.INVENTORY_ITEM_ID
5349: AND msik.ORGANIZATION_ID = mp.ORGANIZATION_ID
5350: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
5351: AND mcr.CROSS_REFERENCE_TYPE = 'GTIN'

Line 5383: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(

5379: END IF; -- checking for duplicate GTIN
5380: -- if no errors then creating a GTIN
5381: IF NOT l_error THEN
5382: Debug_Conc_Log('No Errors - Creating GTIN');
5383: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(
5384: P_SOURCE_SYSTEM_ID => NULL,
5385: P_START_DATE_ACTIVE => NULL,
5386: P_END_DATE_ACTIVE => NULL,
5387: P_OBJECT_VERSION_NUMBER => NULL,

Line 5436: UPDATE MTL_CROSS_REFERENCES_TL

5432: OR (i.EXISTING_GTIN_DESC IS NULL AND i.GTIN_DESCRIPTION IS NOT NULL)
5433: )
5434: THEN
5435: Debug_Conc_Log('Existing GTIN found. Description needs to be updated.');
5436: UPDATE MTL_CROSS_REFERENCES_TL
5437: SET DESCRIPTION = i.GTIN_DESCRIPTION,
5438: LAST_UPDATE_DATE = SYSDATE,
5439: LAST_UPDATED_BY = l_user_id,
5440: LAST_UPDATE_LOGIN = l_login_id,

Line 5542: FROM MTL_CROSS_REFERENCES_B mcr

5538: l_raise_event := FALSE;
5539: -- if a cross reference already exists for the source system item, then end dating it
5540: BEGIN
5541: SELECT ROWID, INVENTORY_ITEM_ID INTO l_rowid, l_item_id
5542: FROM MTL_CROSS_REFERENCES_B mcr
5543: WHERE mcr.SOURCE_SYSTEM_ID = p_source_system_id
5544: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
5545: AND mcr.CROSS_REFERENCE = p_source_system_reference
5546: AND (mcr.END_DATE_ACTIVE IS NULL OR mcr.END_DATE_ACTIVE > SYSDATE);

Line 5551: UPDATE MTL_CROSS_REFERENCES_B

5547:
5548: Debug_Conc_Log('Existing Xref found l_item_id='||to_char(l_item_id));
5549: IF p_inventory_item_id <> NVL(l_item_id, -1) THEN
5550: Debug_Conc_Log('Updating the existing SS Xref, end dating');
5551: UPDATE MTL_CROSS_REFERENCES_B
5552: SET
5553: END_DATE_ACTIVE = SYSDATE,
5554: LAST_UPDATED_BY = l_user_id,
5555: LAST_UPDATE_DATE = SYSDATE,

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

5568: NULL;
5569: END;
5570:
5571: IF p_inventory_item_id <> NVL(l_item_id, -1) THEN
5572: -- calling MTL_CROSS_REFERENCES_B table handler to insert rows
5573: Debug_Conc_Log('Creating SS Xref');
5574: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(
5575: P_SOURCE_SYSTEM_ID => p_source_system_id,
5576: P_START_DATE_ACTIVE => SYSDATE,

Line 5574: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(

5570:
5571: IF p_inventory_item_id <> NVL(l_item_id, -1) THEN
5572: -- calling MTL_CROSS_REFERENCES_B table handler to insert rows
5573: Debug_Conc_Log('Creating SS Xref');
5574: MTL_CROSS_REFERENCES_PKG.INSERT_ROW(
5575: P_SOURCE_SYSTEM_ID => p_source_system_id,
5576: P_START_DATE_ACTIVE => SYSDATE,
5577: P_END_DATE_ACTIVE => NULL,
5578: P_OBJECT_VERSION_NUMBER => NULL,

Line 5643: FROM MTL_CROSS_REFERENCES_B mcr

5639: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5640: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL
5641: AND msi.REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
5642: AND NOT EXISTS (SELECT NULL
5643: FROM MTL_CROSS_REFERENCES_B mcr
5644: WHERE mcr.SOURCE_SYSTEM_ID = msi.SOURCE_SYSTEM_ID
5645: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
5646: AND mcr.CROSS_REFERENCE = msi.SOURCE_SYSTEM_REFERENCE
5647: AND mcr.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID

Line 5661: FROM MTL_SYSTEM_ITEMS_INTERFACE msi, MTL_CROSS_REFERENCES mcr

5657: msi.ORGANIZATION_ID,
5658: msi.TRANSACTION_ID,
5659: msi.TRANSACTION_TYPE,
5660: mcr.CROSS_REFERENCE_ID
5661: FROM MTL_SYSTEM_ITEMS_INTERFACE msi, MTL_CROSS_REFERENCES mcr
5662: WHERE msi.PROCESS_FLAG IN (5, 7)
5663: AND msi.SET_PROCESS_ID = p_data_set_id
5664: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5665: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL

Line 5697: FROM MTL_CROSS_REFERENCES_B mcr

5693: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5694: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL
5695: AND msi.CONFIRM_STATUS IN ('CM', 'CC')
5696: AND NOT EXISTS (SELECT NULL
5697: FROM MTL_CROSS_REFERENCES_B mcr
5698: WHERE mcr.SOURCE_SYSTEM_ID = msi.SOURCE_SYSTEM_ID
5699: AND mcr.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
5700: AND mcr.CROSS_REFERENCE = msi.SOURCE_SYSTEM_REFERENCE
5701: AND mcr.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID

Line 5717: FROM MTL_SYSTEM_ITEMS_INTERFACE msi, MTL_CROSS_REFERENCES mcr

5713: msi.TRANSACTION_ID,
5714: msi.TRANSACTION_TYPE,
5715: mcr.CROSS_REFERENCE_ID,
5716: msi.ROWID AS ROW_ID
5717: FROM MTL_SYSTEM_ITEMS_INTERFACE msi, MTL_CROSS_REFERENCES mcr
5718: WHERE msi.PROCESS_FLAG IN (0, 11)
5719: AND msi.SET_PROCESS_ID = p_data_set_id
5720: AND msi.SOURCE_SYSTEM_ID IS NOT NULL
5721: AND msi.SOURCE_SYSTEM_REFERENCE IS NOT NULL

Line 5780: UPDATE MTL_CROSS_REFERENCES_TL

5776: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5777: l_inventory_item_id := i.INVENTORY_ITEM_ID;
5778:
5779: IF l_inventory_item_id IS NOT NULL THEN
5780: UPDATE MTL_CROSS_REFERENCES_TL
5781: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5782: LAST_UPDATE_DATE = SYSDATE,
5783: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5784: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 5905: UPDATE MTL_CROSS_REFERENCES_TL

5901: Debug_Conc_Log('Processing for SS_ID, SS_REF='||TO_CHAR(i.SOURCE_SYSTEM_ID)||', '||i.SOURCE_SYSTEM_REFERENCE);
5902: l_inventory_item_id := i.INVENTORY_ITEM_ID;
5903:
5904: IF l_inventory_item_id IS NOT NULL THEN
5905: UPDATE MTL_CROSS_REFERENCES_TL
5906: SET DESCRIPTION = i.SOURCE_SYSTEM_REFERENCE_DESC,
5907: LAST_UPDATE_DATE = SYSDATE,
5908: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
5909: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

Line 7336: FROM MTL_CROSS_REFERENCES_B XREF

7332: MTL_SYSTEM_ITEMS_INTERFACE MSII
7333: SET TRANSACTION_TYPE = UPPER( TRANSACTION_TYPE )
7334: , INVENTORY_ITEM_ID =
7335: (SELECT INVENTORY_ITEM_ID
7336: FROM MTL_CROSS_REFERENCES_B XREF
7337: WHERE XREF.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF' AND
7338: XREF.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE AND
7339: XREF.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID AND
7340: SYSDATE BETWEEN NVL(XREF.START_DATE_ACTIVE, SYSDATE - 1) AND NVL(XREF.END_DATE_ACTIVE, SYSDATE + 1) AND #'

Line 8000: MTL_CROSS_REFERENCES MCR

7996: MSII.ORGANIZATION_ID,
7997: MSII.TRANSACTION_ID
7998: FROM MTL_SYSTEM_ITEMS_B_KFV KFV,
7999: MTL_SYSTEM_ITEMS_INTERFACE MSII,
8000: MTL_CROSS_REFERENCES MCR
8001: WHERE MSII.SET_PROCESS_ID = p_data_set_id
8002: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8003: AND MSII.SOURCE_SYSTEM_ID = MCR.SOURCE_SYSTEM_ID
8004: AND MSII.ORGANIZATION_ID = KFV.ORGANIZATION_ID

Line 8159: FROM MTL_CROSS_REFERENCES_VL APPLYSEC

8155: AND ORGANIZATION_ID = :org_id
8156: AND CONFIRM_STATUS IN ('CC', 'CM', 'CFC', 'CFM')
8157: AND EXISTS
8158: (SELECT 1
8159: FROM MTL_CROSS_REFERENCES_VL APPLYSEC
8160: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8161: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8162: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8163: AND APPLYSEC.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID

Line 8183: FROM MTL_CROSS_REFERENCES_B APPLYSEC

8179: AND PROCESS_FLAG = 0
8180: AND ORGANIZATION_ID = :org_id
8181: AND CONFIRM_STATUS IN ('CC', 'CM', 'CFC', 'CFM')
8182: AND EXISTS ( SELECT 1
8183: FROM MTL_CROSS_REFERENCES_B APPLYSEC
8184: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8185: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8186: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8187: AND APPLYSEC.INVENTORY_ITEM_ID <> MSII.INVENTORY_ITEM_ID

Line 8207: FROM MTL_CROSS_REFERENCES_B XREF

8203: AND NOT #' || l_security_predicate || q'#
8204: AND APPLYSEC.INVENTORY_ITEM_ID IS NOT NULL
8205: AND LNNVL (APPLYSEC.INVENTORY_ITEM_ID =
8206: (SELECT XREF.INVENTORY_ITEM_ID
8207: FROM MTL_CROSS_REFERENCES_B XREF
8208: WHERE XREF.CROSS_REFERENCE = APPLYSEC.SOURCE_SYSTEM_REFERENCE
8209: AND XREF.SOURCE_SYSTEM_ID = APPLYSEC.SOURCE_SYSTEM_ID
8210: AND XREF.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8211: AND SYSDATE BETWEEN NVL(XREF.START_DATE_ACTIVE, SYSDATE-1) AND NVL(XREF.END_DATE_ACTIVE, SYSDATE + 1))) #';

Line 8466: AND EXISTS ( SELECT 1 FROM MTL_CROSS_REFERENCES_B APPLYSEC

8462: WHERE SET_PROCESS_ID = :p_data_set_id
8463: AND PROCESS_FLAG = 0
8464: AND ORGANIZATION_ID = :org_id
8465: AND CONFIRM_status = 'CNR'
8466: AND EXISTS ( SELECT 1 FROM MTL_CROSS_REFERENCES_B APPLYSEC
8467: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8468: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8469: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8470: AND SYSDATE BETWEEN NVL(APPLYSEC.START_DATE_ACTIVE, SYSDATE-1) AND NVL(APPLYSEC.END_DATE_ACTIVE, SYSDATE + 1)

Line 8487: FROM MTL_CROSS_REFERENCES_VL APPLYSEC

8483: AND ORGANIZATION_ID = :org_id
8484: AND CONFIRM_STATUS IN ('CCR', 'CMR', 'FMR' )
8485: AND EXISTS
8486: (SELECT 1
8487: FROM MTL_CROSS_REFERENCES_VL APPLYSEC
8488: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8489: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8490: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8491: AND APPLYSEC.INVENTORY_ITEM_ID = MSII.INVENTORY_ITEM_ID

Line 8511: FROM MTL_CROSS_REFERENCES_B APPLYSEC

8507: AND PROCESS_FLAG = 0
8508: AND ORGANIZATION_ID = :org_id
8509: AND CONFIRM_STATUS IN ( 'CCR', 'CMR', 'FMR' )
8510: AND EXISTS ( SELECT 1
8511: FROM MTL_CROSS_REFERENCES_B APPLYSEC
8512: WHERE APPLYSEC.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
8513: AND APPLYSEC.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
8514: AND APPLYSEC.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8515: AND APPLYSEC.INVENTORY_ITEM_ID <> MSII.INVENTORY_ITEM_ID

Line 8536: FROM MTL_CROSS_REFERENCES_B XREF

8532: AND NOT #' || l_security_predicate || q'#
8533: AND APPLYSEC.INVENTORY_ITEM_ID IS NOT NULL
8534: AND LNNVL (APPLYSEC.INVENTORY_ITEM_ID =
8535: (SELECT XREF.INVENTORY_ITEM_ID
8536: FROM MTL_CROSS_REFERENCES_B XREF
8537: WHERE XREF.CROSS_REFERENCE = APPLYSEC.SOURCE_SYSTEM_REFERENCE
8538: AND XREF.SOURCE_SYSTEM_ID = APPLYSEC.SOURCE_SYSTEM_ID
8539: AND XREF.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
8540: AND SYSDATE BETWEEN NVL(XREF.START_DATE_ACTIVE, SYSDATE-1) AND NVL(XREF.END_DATE_ACTIVE, SYSDATE + 1))) #';

Line 9027: FROM MTL_CROSS_REFERENCES_B MCR

9023: (SELECT
9024: 1,
9025: NVL(MSII.TRANSACTION_TYPE, 'SYNC'),
9026: MCR.INVENTORY_ITEM_ID
9027: FROM MTL_CROSS_REFERENCES_B MCR
9028: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9029: AND MCR.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
9030: AND MCR.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
9031: AND SYSDATE BETWEEN NVL(MCR.START_DATE_ACTIVE, SYSDATE - 1) AND NVL(MCR.END_DATE_ACTIVE, SYSDATE + 1)

Line 9053: FROM MTL_CROSS_REFERENCES_B MCR

9049: AND MSII2.ORGANIZATION_ID = :l_org_id1
9050: )
9051: -- HAS A CROSS REFERENCE
9052: AND EXISTS (SELECT NULL
9053: FROM MTL_CROSS_REFERENCES_B MCR
9054: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9055: AND MCR.CROSS_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
9056: AND MCR.SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
9057: AND SYSDATE BETWEEN NVL(MCR.START_DATE_ACTIVE, SYSDATE - 1) AND NVL(MCR.END_DATE_ACTIVE, SYSDATE + 1)

Line 9072: FROM MTL_CROSS_REFERENCES_B MCR

9068: (SELECT
9069: 1,
9070: NVL(MIRI.TRANSACTION_TYPE, 'SYNC'),
9071: MCR.INVENTORY_ITEM_ID
9072: FROM MTL_CROSS_REFERENCES_B MCR
9073: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9074: AND MCR.CROSS_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
9075: AND MCR.SOURCE_SYSTEM_ID = MIRI.SOURCE_SYSTEM_ID
9076: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9093: FROM MTL_CROSS_REFERENCES_B MCR

9089: AND MSII.ORGANIZATION_ID = :l_org_id
9090: )
9091: -- HAS A CROSS REFERENCE
9092: AND EXISTS (SELECT NULL
9093: FROM MTL_CROSS_REFERENCES_B MCR
9094: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9095: AND MCR.CROSS_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
9096: AND MCR.SOURCE_SYSTEM_ID = MIRI.SOURCE_SYSTEM_ID
9097: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9129: FROM MTL_CROSS_REFERENCES_B MCR

9125: AND MSII.ORGANIZATION_ID = :l_org_id
9126: )
9127: -- HAS A CROSS REFERENCE
9128: AND EXISTS (SELECT NULL
9129: FROM MTL_CROSS_REFERENCES_B MCR
9130: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9131: AND MCR.CROSS_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
9132: AND MCR.SOURCE_SYSTEM_ID = MIRI.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: (SELECT
9147: 1,
9148: MICI.TRANSACTION_TYPE,
9149: MCR.INVENTORY_ITEM_ID
9150: FROM MTL_CROSS_REFERENCES_B MCR
9151: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9152: AND MCR.CROSS_REFERENCE = MICI.SOURCE_SYSTEM_REFERENCE
9153: AND MCR.SOURCE_SYSTEM_ID = MICI.SOURCE_SYSTEM_ID
9154: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9171: FROM MTL_CROSS_REFERENCES_B MCR

9167: AND MSII.ORGANIZATION_ID = :l_org_id
9168: )
9169: -- HAS A CROSS REFERENCE
9170: AND EXISTS (SELECT NULL
9171: FROM MTL_CROSS_REFERENCES_B MCR
9172: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9173: AND MCR.CROSS_REFERENCE = MICI.SOURCE_SYSTEM_REFERENCE
9174: AND MCR.SOURCE_SYSTEM_ID = MICI.SOURCE_SYSTEM_ID
9175: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9191: FROM MTL_CROSS_REFERENCES_B MCR

9187: (SELECT
9188: 1,
9189: NVL(EIPI.TRANSACTION_TYPE, 'SYNC'),
9190: MCR.INVENTORY_ITEM_ID
9191: FROM MTL_CROSS_REFERENCES_B MCR
9192: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9193: AND MCR.CROSS_REFERENCE = EIPI.SOURCE_SYSTEM_REFERENCE
9194: AND MCR.SOURCE_SYSTEM_ID = EIPI.SOURCE_SYSTEM_ID
9195: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9212: FROM MTL_CROSS_REFERENCES_B MCR

9208: AND MSII.ORGANIZATION_ID = :l_org_id
9209: )
9210: -- HAS A CROSS REFERENCE
9211: AND EXISTS (SELECT NULL
9212: FROM MTL_CROSS_REFERENCES_B MCR
9213: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9214: AND MCR.CROSS_REFERENCE = EIPI.SOURCE_SYSTEM_REFERENCE
9215: AND MCR.SOURCE_SYSTEM_ID = EIPI.SOURCE_SYSTEM_ID
9216: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9232: FROM MTL_CROSS_REFERENCES_B MCR

9228: (SELECT
9229: 1,
9230: NVL(EIUAI.TRANSACTION_TYPE, 'SYNC'),
9231: MCR.INVENTORY_ITEM_ID
9232: FROM MTL_CROSS_REFERENCES_B MCR
9233: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9234: AND MCR.CROSS_REFERENCE = EIUAI.SOURCE_SYSTEM_REFERENCE
9235: AND MCR.SOURCE_SYSTEM_ID = EIUAI.SOURCE_SYSTEM_ID
9236: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9253: FROM MTL_CROSS_REFERENCES_B MCR

9249: AND MSII.ORGANIZATION_ID = :l_org_id
9250: )
9251: -- HAS A CROSS REFERENCE
9252: AND EXISTS (SELECT NULL
9253: FROM MTL_CROSS_REFERENCES_B MCR
9254: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9255: AND MCR.CROSS_REFERENCE = EIUAI.SOURCE_SYSTEM_REFERENCE
9256: AND MCR.SOURCE_SYSTEM_ID = EIUAI.SOURCE_SYSTEM_ID
9257: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9273: FROM MTL_CROSS_REFERENCES_B MCR

9269: (SELECT
9270: 1,
9271: NVL(EAI.TRANSACTION_TYPE, 'SYNC'),
9272: MCR.INVENTORY_ITEM_ID
9273: FROM MTL_CROSS_REFERENCES_B MCR
9274: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9275: AND MCR.CROSS_REFERENCE = EAI.SOURCE_SYSTEM_REFERENCE
9276: AND MCR.SOURCE_SYSTEM_ID = EAI.SOURCE_SYSTEM_ID
9277: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9294: FROM MTL_CROSS_REFERENCES_B MCR

9290: AND MSII.ORGANIZATION_ID = :l_org_id
9291: )
9292: -- HAS A CROSS REFERENCE
9293: AND EXISTS (SELECT NULL
9294: FROM MTL_CROSS_REFERENCES_B MCR
9295: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9296: AND MCR.CROSS_REFERENCE = EAI.SOURCE_SYSTEM_REFERENCE
9297: AND MCR.SOURCE_SYSTEM_ID = EAI.SOURCE_SYSTEM_ID
9298: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9314: FROM MTL_CROSS_REFERENCES_B MCR

9310: (SELECT
9311: 1,
9312: EIAI.TRANSACTION_TYPE,
9313: MCR.INVENTORY_ITEM_ID
9314: FROM MTL_CROSS_REFERENCES_B MCR
9315: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9316: AND MCR.CROSS_REFERENCE = EIAI.SOURCE_SYSTEM_REFERENCE
9317: AND MCR.SOURCE_SYSTEM_ID = EIAI.SOURCE_SYSTEM_ID
9318: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9335: FROM MTL_CROSS_REFERENCES_B MCR

9331: AND MSII.ORGANIZATION_ID = :l_org_id
9332: )
9333: -- HAS A CROSS REFERENCE
9334: AND EXISTS (SELECT NULL
9335: FROM MTL_CROSS_REFERENCES_B MCR
9336: WHERE MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'
9337: AND MCR.CROSS_REFERENCE = EIAI.SOURCE_SYSTEM_REFERENCE
9338: AND MCR.SOURCE_SYSTEM_ID = EIAI.SOURCE_SYSTEM_ID
9339: AND (MCR.START_DATE_ACTIVE < SYSDATE OR MCR.START_DATE_ACTIVE IS NULL)

Line 9536: l_xref_desc MTL_CROSS_REFERENCES.DESCRIPTION%TYPE;

9532: l_priv_exists VARCHAR2(1);
9533: l_msg_text VARCHAR2(4000);
9534: l_xref_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
9535: l_xref_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
9536: l_xref_desc MTL_CROSS_REFERENCES.DESCRIPTION%TYPE;
9537: l_org_code MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_CODE%TYPE;
9538: l_party_name VARCHAR2(1000); -- Bug: 5355759
9539: BEGIN
9540: x_return_code := 0;

Line 9905: FROM MTL_CROSS_REFERENCES MCR,

9901: , MCR.DESCRIPTION
9902: INTO l_xref_item_number
9903: , l_xref_item_id
9904: , l_xref_desc
9905: FROM MTL_CROSS_REFERENCES MCR,
9906: MTL_SYSTEM_ITEMS_KFV MSIK
9907: WHERE MCR.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
9908: AND MSIK.ORGANIZATION_ID = l_org_id
9909: AND MCR.CROSS_REFERENCE_TYPE = 'SS_ITEM_XREF'