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_PARAMETERS

Line 762: FROM MTL_PARAMETERS MP

758: SELECT MP.ORGANIZATION_ID,
759: BA.SOURCE_SYSTEM_ID
760: INTO l_org_id
761: , l_ss_id
762: FROM MTL_PARAMETERS MP
763: , EGO_IMPORT_BATCHES_B ba
764: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID
765: AND BA.BATCH_ID = p_batch_id;
766: EXCEPTION

Line 807: FROM MTL_PARAMETERS P

803: , ATTR_GROUP_INT_NAME
804: , ATTR_INT_NAME
805: , COALESCE( EIUAI.ORGANIZATION_ID,
806: ( SELECT ORGANIZATION_ID
807: FROM MTL_PARAMETERS P
808: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
809: ),
810: ( SELECT ORGANIZATION_ID
811: FROM MTL_ITEM_REVISIONS_B R

Line 831: FROM MTL_PARAMETERS P

827: , ATTR_GROUP_INT_NAME
828: , ATTR_INT_NAME
829: , COALESCE( EIUAI.ORGANIZATION_ID,
830: ( SELECT ORGANIZATION_ID
831: FROM MTL_PARAMETERS P
832: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
833: ),
834: ( SELECT ORGANIZATION_ID
835: FROM MTL_ITEM_REVISIONS_B R

Line 891: FROM MTL_PARAMETERS P

887: , ATTR_GROUP_INT_NAME
888: , ATTR_INT_NAME
889: , COALESCE( EIUAI.ORGANIZATION_ID,
890: ( SELECT ORGANIZATION_ID
891: FROM MTL_PARAMETERS P
892: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
893: ),
894: ( SELECT ORGANIZATION_ID
895: FROM MTL_ITEM_REVISIONS_B R

Line 916: FROM MTL_PARAMETERS P

912: , ATTR_GROUP_INT_NAME
913: , ATTR_INT_NAME
914: , COALESCE( EIUAI.ORGANIZATION_ID,
915: ( SELECT ORGANIZATION_ID
916: FROM MTL_PARAMETERS P
917: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
918: ),
919: ( SELECT ORGANIZATION_ID
920: FROM MTL_ITEM_REVISIONS_B R

Line 1243: FROM MTL_PARAMETERS p

1239: , PK4_VALUE
1240: , PK5_VALUE
1241: , COALESCE ( eiuai.ORGANIZATION_ID
1242: , ( SELECT ORGANIZATION_ID
1243: FROM MTL_PARAMETERS p
1244: WHERE p.ORGANIZATION_CODE = eiuai.ORGANIZATION_CODE
1245: )
1246: , NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
1247: )

Line 1263: FROM MTL_PARAMETERS p

1259: , PK4_VALUE
1260: , PK5_VALUE
1261: , COALESCE ( eiuai.ORGANIZATION_ID
1262: , ( SELECT ORGANIZATION_ID
1263: FROM MTL_PARAMETERS p
1264: WHERE p.ORGANIZATION_CODE = eiuai.ORGANIZATION_CODE
1265: )
1266: , NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
1267: )

Line 1321: FROM MTL_PARAMETERS p

1317: , PK4_VALUE
1318: , PK5_VALUE
1319: , COALESCE ( eiuai.ORGANIZATION_ID
1320: , ( SELECT ORGANIZATION_ID
1321: FROM MTL_PARAMETERS p
1322: WHERE p.ORGANIZATION_CODE = eiuai.ORGANIZATION_CODE
1323: )
1324: , NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
1325: )

Line 1342: FROM MTL_PARAMETERS p

1338: , PK4_VALUE
1339: , PK5_VALUE
1340: , COALESCE ( eiuai.ORGANIZATION_ID
1341: , ( SELECT ORGANIZATION_ID
1342: FROM MTL_PARAMETERS p
1343: WHERE p.ORGANIZATION_CODE = eiuai.ORGANIZATION_CODE
1344: )
1345: , NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
1346: )

Line 1711: FROM MTL_PARAMETERS mp

1707: )
1708: AND ITEM_NUMBER IS NOT NULL
1709: AND ORGANIZATION_ID IS NOT NULL
1710: AND EXISTS ( SELECT NULL
1711: FROM MTL_PARAMETERS mp
1712: WHERE mp.ORGANIZATION_ID = msii.ORGANIZATION_ID
1713: AND mp.MASTER_ORGANIZATION_ID = l_org_id
1714: )
1715: )

Line 1751: FROM MTL_PARAMETERS mp

1747: AND SOURCE_SYSTEM_ID = l_ss_id
1748: AND SOURCE_SYSTEM_REFERENCE IS NOT NULL
1749: AND ORGANIZATION_ID IS NOT NULL
1750: AND EXISTS ( SELECT NULL
1751: FROM MTL_PARAMETERS mp
1752: WHERE mp.ORGANIZATION_ID = msii.ORGANIZATION_ID
1753: AND mp.MASTER_ORGANIZATION_ID = l_org_id
1754: )
1755: )

Line 2480: FROM mtl_parameters mp

2476: and SOURCE_SYSTEM_ID = cp_ss_id
2477: and SOURCE_SYSTEM_REFERENCE IS NOT NULL
2478: AND ORGANIZATION_ID IS NOT NULL
2479: and EXISTS ( SELECT null
2480: FROM mtl_parameters mp
2481: WHERE mp.ORGANIZATION_ID = miri.ORGANIZATION_ID
2482: and mp.MASTER_ORGANIZATION_ID = cp_master_org_id
2483: )
2484: )

Line 2527: FROM mtl_parameters mp

2523: AND ( SOURCE_SYSTEM_ID IS NULL
2524: OR SOURCE_SYSTEM_ID = G_PDH_SOURCE_SYSTEM_ID
2525: )
2526: AND EXISTS ( SELECT null
2527: FROM mtl_parameters mp
2528: WHERE mp.organization_id = miri.organization_id
2529: AND mp.master_organization_id = cp_master_org_id
2530: )
2531: )

Line 3146: FROM MTL_PARAMETERS mp

3142: AND ITEM_NUMBER IS NOT NULL
3143: AND ORGANIZATION_ID IS NOT NULL
3144: AND EXISTS
3145: (SELECT NULL
3146: FROM MTL_PARAMETERS mp
3147: WHERE mp.ORGANIZATION_ID = msii.ORGANIZATION_ID
3148: AND mp.MASTER_ORGANIZATION_ID = l_org_id
3149: )
3150: ) sub

Line 3774: FROM MTL_PARAMETERS mp

3770: AND ORGANIZATION_ID IS NOT NULL
3771: AND REVISION IS NOT NULL
3772: AND EXISTS
3773: (SELECT NULL
3774: FROM MTL_PARAMETERS mp
3775: WHERE mp.ORGANIZATION_ID = miri.ORGANIZATION_ID
3776: AND mp.MASTER_ORGANIZATION_ID = p_master_org_id
3777: )
3778: ) sub

Line 4039: FROM MTL_PARAMETERS mp

4035: AND CATEGORY_SET_NAME IS NOT NULL
4036: AND CATEGORY_NAME IS NOT NULL
4037: AND EXISTS
4038: (SELECT NULL
4039: FROM MTL_PARAMETERS mp
4040: WHERE mp.ORGANIZATION_ID = mici.ORGANIZATION_ID
4041: AND mp.MASTER_ORGANIZATION_ID = p_master_org_id
4042: )
4043: ) sub

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 5929: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;

5925: p_status IN VARCHAR2,
5926: p_inventory_item_id IN NUMBER DEFAULT NULL,
5927: p_organization_id IN NUMBER DEFAULT NULL)
5928: IS
5929: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
5930: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
5931: unexpected_parameters EXCEPTION;
5932: BEGIN
5933: -- Check that the parameters satisfy the assumptions: if they don't, raise error

Line 5930: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

5926: p_inventory_item_id IN NUMBER DEFAULT NULL,
5927: p_organization_id IN NUMBER DEFAULT NULL)
5928: IS
5929: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
5930: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
5931: unexpected_parameters EXCEPTION;
5932: BEGIN
5933: -- Check that the parameters satisfy the assumptions: if they don't, raise error
5934:

Line 5958: FROM MTL_PARAMETERS MP,

5954: SELECT
5955: MP.ORGANIZATION_ID,
5956: MP.ORGANIZATION_CODE
5957: INTO l_org_id, l_org_code
5958: FROM MTL_PARAMETERS MP,
5959: EGO_IMPORT_BATCHES_B BA
5960: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND
5961: BA.BATCH_ID = p_data_set_id;
5962:

Line 6117: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;

6113: l_pdh_item_catalog_group_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
6114: l_confirm_status MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE;
6115: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6116: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6117: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6118: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6119: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
6120: l_instance_rev_policy MTL_SYSTEM_ITEMS_INTERFACE.REVISION_IMPORT_POLICY%TYPE;
6121: l_style_item_flag MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_FLAG%TYPE;

Line 6118: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

6114: l_confirm_status MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE;
6115: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6116: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6117: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6118: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6119: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
6120: l_instance_rev_policy MTL_SYSTEM_ITEMS_INTERFACE.REVISION_IMPORT_POLICY%TYPE;
6121: l_style_item_flag MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_FLAG%TYPE;
6122: BEGIN

Line 6128: FROM MTL_PARAMETERS MP,

6124: MP.ORGANIZATION_ID,
6125: MP.ORGANIZATION_CODE,
6126: NVL(OPT.REVISION_IMPORT_POLICY, 'L')
6127: INTO l_organization_id, l_organization_code, l_batch_rev_policy
6128: FROM MTL_PARAMETERS MP,
6129: EGO_IMPORT_BATCHES_B ba,
6130: EGO_IMPORT_OPTION_SETS OPT
6131: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND
6132: BA.BATCH_ID = OPT.BATCH_ID AND

Line 6281: FROM mtl_parameters mp

6277: WHERE set_process_id = p_set_id
6278: AND process_flag = 0
6279: AND organization_id /*bug 6402904 parse for child items also*/
6280: IN (SELECT organization_id
6281: FROM mtl_parameters mp
6282: WHERE mp.master_organization_id = p_master_org_id)
6283: AND ( confirm_status IS NULL
6284: OR confirm_status = G_FAKE_CONF_STATUS_FLAG
6285: )

Line 6410: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;

6406: PROCEDURE Resolve_SSXref_on_Data_load( p_data_set_id IN NUMBER
6407: ,p_commit IN FLAG DEFAULT FND_API.G_TRUE
6408: )
6409: IS
6410: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6411: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6412: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_id%TYPE;
6413: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
6414: l_party_name VARCHAR2(1000);

Line 6411: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

6407: ,p_commit IN FLAG DEFAULT FND_API.G_TRUE
6408: )
6409: IS
6410: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6411: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6412: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_id%TYPE;
6413: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
6414: l_party_name VARCHAR2(1000);
6415: l_security_predicate VARCHAR2(4000);

Line 6439: FROM MTL_PARAMETERS MP,

6435: BA.SOURCE_SYSTEM_ID,
6436: NVL(OPT.IMPORT_XREF_ONLY, 'N'),
6437: NVL(ENABLED_FOR_DATA_POOL, 'N')
6438: INTO l_org_id, l_org_code, l_ss_id, l_import_xref_only, l_enabled_for_data_pool
6439: FROM MTL_PARAMETERS MP,
6440: EGO_IMPORT_BATCHES_B BA,
6441: EGO_IMPORT_OPTION_SETS OPT
6442: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID
6443: AND BA.BATCH_ID = p_data_set_id

Line 6452: FROM MTL_PARAMETERS mp, MTL_PARAMETERS mp1

6448: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
6449: BEGIN
6450: SELECT mp.MASTER_ORGANIZATION_ID, mp1.ORGANIZATION_CODE
6451: INTO l_org_id, l_org_code
6452: FROM MTL_PARAMETERS mp, MTL_PARAMETERS mp1
6453: WHERE mp.ORGANIZATION_ID = TO_NUMBER(l_org)
6454: AND mp.MASTER_ORGANIZATION_ID = mp1.ORGANIZATION_ID;
6455: EXCEPTION WHEN OTHERS THEN
6456: l_org_id := NULL;

Line 6471: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MSII.ORGANIZATION_CODE)

6467: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
6468: SET ORGANIZATION_ID =
6469: CASE
6470: WHEN ORGANIZATION_CODE IS NOT NULL
6471: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MSII.ORGANIZATION_CODE)
6472: ELSE l_org_id
6473: END
6474: WHERE SET_PROCESS_ID = p_data_set_id AND
6475: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

Line 6483: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MIRI.ORGANIZATION_CODE)

6479: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
6480: SET ORGANIZATION_ID =
6481: CASE
6482: WHEN ORGANIZATION_CODE IS NOT NULL
6483: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MIRI.ORGANIZATION_CODE)
6484: ELSE l_org_id
6485: END
6486: WHERE SET_PROCESS_ID = p_data_set_id AND
6487: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

Line 6495: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MICI.ORGANIZATION_CODE)

6491: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
6492: SET ORGANIZATION_ID =
6493: CASE
6494: WHEN ORGANIZATION_CODE IS NOT NULL
6495: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MICI.ORGANIZATION_CODE)
6496: ELSE l_org_id
6497: END
6498: WHERE SET_PROCESS_ID = p_data_set_id AND
6499: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

Line 6506: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE)

6502: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
6503: SET ORGANIZATION_ID =
6504: CASE
6505: WHEN ORGANIZATION_CODE IS NOT NULL
6506: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE)
6507: ELSE l_org_id
6508: END
6509: WHERE DATA_SET_ID = p_data_set_id AND
6510: (PROCESS_STATUS IS NULL OR PROCESS_STATUS IN (0, 1)) AND

Line 6517: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIPI.ORGANIZATION_CODE)

6513: UPDATE EGO_ITEM_PEOPLE_INTF EIPI
6514: SET ORGANIZATION_ID =
6515: CASE
6516: WHEN ORGANIZATION_CODE IS NOT NULL
6517: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIPI.ORGANIZATION_CODE)
6518: ELSE l_org_id
6519: END
6520: WHERE DATA_SET_ID = p_data_set_id AND
6521: (PROCESS_STATUS IS NULL OR PROCESS_STATUS IN (0, 1)) AND

Line 6528: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EAI.ORGANIZATION_CODE)

6524: UPDATE EGO_AML_INTF EAI
6525: SET ORGANIZATION_ID =
6526: CASE
6527: WHEN ORGANIZATION_CODE IS NOT NULL
6528: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EAI.ORGANIZATION_CODE)
6529: ELSE l_org_id
6530: END
6531: WHERE DATA_SET_ID = p_data_set_id AND
6532: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

Line 6539: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIAI.ORGANIZATION_CODE)

6535: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
6536: SET ORGANIZATION_ID =
6537: CASE
6538: WHEN ORGANIZATION_CODE IS NOT NULL
6539: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIAI.ORGANIZATION_CODE)
6540: ELSE l_org_id
6541: END
6542: WHERE BATCH_ID = p_data_set_id AND
6543: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

Line 6768: -- , MTL_PARAMETERS MP

6764: , MAX( EIUAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6765: , MAX( EIUAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6766: , MAX( EIUAI.item_catalog_group_id ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) ITEM_CATALOG_GROUP_ID
6767: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
6768: -- , MTL_PARAMETERS MP
6769: WHERE
6770: data_set_id = p_data_set_id
6771: AND process_status = 1
6772: AND EIUAI.organization_id = l_org_id

Line 6802: -- , MTL_PARAMETERS MP

6798: , MAX( EAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
6799: , MAX( EAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6800: , MAX( EAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6801: FROM EGO_AML_INTF EAI
6802: -- , MTL_PARAMETERS MP
6803: WHERE
6804: EAI.data_set_id = p_data_set_id
6805: AND EAI.process_flag = 1
6806: AND EAI.organization_id = l_org_id

Line 6985: -- , MTL_PARAMETERS MP

6981: , MAX( EIUAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6982: , MAX( EIUAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6983: , MAX( EIUAI.item_catalog_group_id ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) ITEM_CATALOG_GROUP_ID
6984: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
6985: -- , MTL_PARAMETERS MP
6986: WHERE
6987: data_set_id = p_data_set_id
6988: AND process_status = 0
6989: AND EIUAI.organization_id = l_org_id

Line 7024: -- , MTL_PARAMETERS MP

7020: , MAX( EAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
7021: , MAX( EAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
7022: , MAX( EAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
7023: FROM EGO_AML_INTF EAI
7024: -- , MTL_PARAMETERS MP
7025: WHERE
7026: EAI.data_set_id = p_data_set_id
7027: AND EAI.process_flag = 0
7028: AND EAI.organization_id = l_org_id

Line 7950: FROM MTL_PARAMETERS mp

7946: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
7947: BEGIN
7948: SELECT mp.MASTER_ORGANIZATION_ID
7949: INTO l_org_id
7950: FROM MTL_PARAMETERS mp
7951: WHERE mp.ORGANIZATION_ID = TO_NUMBER(l_org);
7952: EXCEPTION WHEN OTHERS THEN
7953: l_org_id := NULL;
7954: END;

Line 8001: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp

7997: 'Y', 'Y'
7998: ),
7999: NVL(MAX(msik.STYLE_ITEM_ID), msii.STYLE_ITEM_ID),
8000: NVL(msii.INVENTORY_ITEM_ID, MAX(msik.INVENTORY_ITEM_ID))
8001: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp
8002: WHERE (msii.INVENTORY_ITEM_ID = msik.INVENTORY_ITEM_ID
8003: OR msii.ITEM_NUMBER = msik.CONCATENATED_SEGMENTS)
8004: AND msik.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
8005: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 8554: AND EXISTS (SELECT NULL FROM MTL_PARAMETERS mp

8550: )
8551: WHERE MSII.PROCESS_FLAG = 0
8552: AND MSII.CONFIRM_STATUS IS NULL
8553: AND MSII.SET_PROCESS_ID = p_data_set_id
8554: AND EXISTS (SELECT NULL FROM MTL_PARAMETERS mp
8555: WHERE mp.ORGANIZATION_ID = MSII.ORGANIZATION_ID
8556: AND mp.MASTER_ORGANIZATION_ID = l_org_id
8557: AND mp.MASTER_ORGANIZATION_ID <> mp.ORGANIZATION_ID
8558: )

Line 8719: FROM MTL_PARAMETERS

8715: AND ROWNUM = 1
8716: )
8717: WHEN '3'
8718: THEN (SELECT STARTING_REVISION
8719: FROM MTL_PARAMETERS
8720: WHERE ORGANIZATION_ID = ATTRS.ORGANIZATION_ID
8721: )
8722: END)
8723: WHERE ATTRS.PROCESS_STATUS = 1

Line 8772: FROM MTL_PARAMETERS

8768: AND MSII.SOURCE_SYSTEM_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
8769: AND MSII.ORGANIZATION_ID = l_org_id)
8770: )
8771: THEN (SELECT STARTING_REVISION
8772: FROM MTL_PARAMETERS
8773: WHERE ORGANIZATION_ID = MIRI.ORGANIZATION_ID
8774: )
8775: END) AS REVISION,
8776: 'SYNC' AS TRANSACTION_TYPE

Line 8935: FROM MTL_PARAMETERS MP

8931: WHERE MSII.SET_PROCESS_ID = :p_data_set_id
8932: AND MSII.PROCESS_FLAG = 0
8933: -- PICK ONLY CHILD ITEMS
8934: AND EXISTS (SELECT NULL
8935: FROM MTL_PARAMETERS MP
8936: WHERE MP.MASTER_ORGANIZATION_ID = :l_org_id
8937: AND MP.ORGANIZATION_ID <> MP.MASTER_ORGANIZATION_ID
8938: AND MP.ORGANIZATION_ID = MSII.ORGANIZATION_ID)
8939: -- CHILD MUST NOT HAVE A MASTER RECORD IN CURRENT BATCH

Line 9307: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp

9303: 'N', 'N',
9304: 'Y', 'Y'
9305: ),
9306: NVL(MAX(msik.STYLE_ITEM_ID), msii.STYLE_ITEM_ID)
9307: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp
9308: WHERE (msii.INVENTORY_ITEM_ID = msik.INVENTORY_ITEM_ID
9309: OR msii.ITEM_NUMBER = msik.CONCATENATED_SEGMENTS)
9310: AND msik.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
9311: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 9522: FROM MTL_PARAMETERS MP

9518: AND PROCESS_FLAG = 3
9519: AND SET_PROCESS_ID = p_batch_id
9520: AND REQUEST_ID = l_request_id
9521: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9522: FROM MTL_PARAMETERS MP
9523: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9524: AND MP.ORGANIZATION_ID <> l_org_id
9525: );
9526: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );

Line 9540: FROM MTL_PARAMETERS MP

9536: AND PROCESS_FLAG = 3
9537: AND SET_PROCESS_ID = p_batch_id
9538: AND REQUEST_ID = l_request_id
9539: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9540: FROM MTL_PARAMETERS MP
9541: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9542: );
9543: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9544:

Line 9557: FROM MTL_PARAMETERS MP

9553: AND PROCESS_FLAG = 3
9554: AND SET_PROCESS_ID = p_batch_id
9555: AND REQUEST_ID = l_request_id
9556: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9557: FROM MTL_PARAMETERS MP
9558: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9559: );
9560: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9561:

Line 9574: FROM MTL_PARAMETERS MP

9570: AND PROCESS_STATUS = 3
9571: AND DATA_SET_ID = p_batch_id
9572: AND REQUEST_ID = l_request_id
9573: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9574: FROM MTL_PARAMETERS MP
9575: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9576: );
9577: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9578:

Line 9591: FROM MTL_PARAMETERS MP

9587: AND PROCESS_STATUS = 3
9588: AND DATA_SET_ID = p_batch_id
9589: AND REQUEST_ID = l_request_id
9590: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9591: FROM MTL_PARAMETERS MP
9592: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9593: );
9594: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9595:

Line 9608: FROM MTL_PARAMETERS MP

9604: AND PROCESS_FLAG = 3
9605: AND DATA_SET_ID = p_batch_id
9606: AND REQUEST_ID = l_request_id
9607: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9608: FROM MTL_PARAMETERS MP
9609: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9610: );
9611: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9612:

Line 9624: FROM MTL_PARAMETERS MP

9620: AND PROCESS_FLAG = 3
9621: AND BATCH_ID = p_batch_id
9622: AND REQUEST_ID = l_request_id
9623: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9624: FROM MTL_PARAMETERS MP
9625: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9626: );
9627: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9628: ELSE -- item id is null

Line 9637: FROM MTL_PARAMETERS MP

9633: AND PROCESS_FLAG = 3
9634: AND SET_PROCESS_ID = p_batch_id
9635: AND REQUEST_ID = l_request_id
9636: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9637: FROM MTL_PARAMETERS MP
9638: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9639: AND MP.ORGANIZATION_ID <> l_org_id
9640: );
9641: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );

Line 9651: FROM MTL_PARAMETERS MP

9647: AND PROCESS_FLAG = 3
9648: AND SET_PROCESS_ID = p_batch_id
9649: AND REQUEST_ID = l_request_id
9650: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9651: FROM MTL_PARAMETERS MP
9652: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9653: );
9654: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9655:

Line 9664: FROM MTL_PARAMETERS MP

9660: AND PROCESS_FLAG = 3
9661: AND SET_PROCESS_ID = p_batch_id
9662: AND REQUEST_ID = l_request_id
9663: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9664: FROM MTL_PARAMETERS MP
9665: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9666: );
9667: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9668:

Line 9677: FROM MTL_PARAMETERS MP

9673: AND PROCESS_STATUS = 3
9674: AND DATA_SET_ID = p_batch_id
9675: AND REQUEST_ID = l_request_id
9676: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9677: FROM MTL_PARAMETERS MP
9678: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9679: );
9680: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9681:

Line 9690: FROM MTL_PARAMETERS MP

9686: AND PROCESS_STATUS = 3
9687: AND DATA_SET_ID = p_batch_id
9688: AND REQUEST_ID = l_request_id
9689: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9690: FROM MTL_PARAMETERS MP
9691: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9692: );
9693: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9694:

Line 9703: FROM MTL_PARAMETERS MP

9699: AND PROCESS_FLAG = 3
9700: AND DATA_SET_ID = p_batch_id
9701: AND REQUEST_ID = l_request_id
9702: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9703: FROM MTL_PARAMETERS MP
9704: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9705: );
9706: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9707: -- updating item ITEM ASSOCIATIONS

Line 9715: FROM MTL_PARAMETERS MP

9711: AND PROCESS_FLAG = 3
9712: AND BATCH_ID = p_batch_id
9713: AND REQUEST_ID = l_request_id
9714: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9715: FROM MTL_PARAMETERS MP
9716: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9717: );
9718: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9719: END IF;

Line 9788: FROM MTL_PARAMETERS

9784:
9785: BEGIN
9786: SELECT ORGANIZATION_CODE
9787: INTO l_org_code
9788: FROM MTL_PARAMETERS
9789: WHERE ORGANIZATION_ID = l_org_id;
9790: EXCEPTION
9791: WHEN NO_DATA_FOUND THEN
9792: NULL;

Line 9896: FROM MTL_PARAMETERS MP

9892: AND PROCESS_FLAG = 3
9893: AND SET_PROCESS_ID = p_batch_id
9894: AND REQUEST_ID = l_request_id
9895: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID -- org assignment
9896: FROM MTL_PARAMETERS MP
9897: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9898: AND MP.ORGANIZATION_ID <> l_org_id
9899: );
9900: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );

Line 9911: FROM MTL_PARAMETERS MP

9907: AND PROCESS_FLAG = 3
9908: AND SET_PROCESS_ID = p_batch_id
9909: AND REQUEST_ID = l_request_id
9910: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9911: FROM MTL_PARAMETERS MP
9912: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9913: );
9914: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9915:

Line 9925: FROM MTL_PARAMETERS MP

9921: AND PROCESS_FLAG = 3
9922: AND SET_PROCESS_ID = p_batch_id
9923: AND REQUEST_ID = l_request_id
9924: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9925: FROM MTL_PARAMETERS MP
9926: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9927: );
9928: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9929:

Line 9939: FROM MTL_PARAMETERS MP

9935: AND PROCESS_STATUS = 3
9936: AND DATA_SET_ID = p_batch_id
9937: AND REQUEST_ID = l_request_id
9938: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9939: FROM MTL_PARAMETERS MP
9940: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9941: );
9942: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9943:

Line 9953: FROM MTL_PARAMETERS MP

9949: AND PROCESS_STATUS = 3
9950: AND DATA_SET_ID = p_batch_id
9951: AND REQUEST_ID = l_request_id
9952: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9953: FROM MTL_PARAMETERS MP
9954: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9955: );
9956: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9957:

Line 9967: FROM MTL_PARAMETERS MP

9963: AND PROCESS_FLAG = 3
9964: AND DATA_SET_ID = p_batch_id
9965: AND REQUEST_ID = l_request_id
9966: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9967: FROM MTL_PARAMETERS MP
9968: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9969: );
9970: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9971: UPDATE EGO_ITEM_ASSOCIATIONS_INTF

Line 9979: FROM MTL_PARAMETERS MP

9975: AND PROCESS_FLAG = 3
9976: AND BATCH_ID = p_batch_id
9977: AND REQUEST_ID = l_request_id
9978: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9979: FROM MTL_PARAMETERS MP
9980: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9981: );
9982: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9983: END IF; -- IF l_is_ssxref_only

Line 11899: FROM MTL_PARAMETERS MP

11895: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
11896: SET ORGANIZATION_ID =
11897: NVL(ORGANIZATION_ID,
11898: (SELECT MP.ORGANIZATION_ID
11899: FROM MTL_PARAMETERS MP
11900: WHERE MP.ORGANIZATION_CODE = MSII.ORGANIZATION_CODE))
11901: ,ITEM_CATALOG_GROUP_ID =
11902: NVL(ITEM_CATALOG_GROUP_ID,
11903: (SELECT MICG.ITEM_CATALOG_GROUP_ID

Line 11918: FROM MTL_PARAMETERS MP

11914: UPDATE EGO_AML_INTF EAI
11915: SET ORGANIZATION_ID =
11916: NVL(ORGANIZATION_ID,
11917: (SELECT MP.ORGANIZATION_ID
11918: FROM MTL_PARAMETERS MP
11919: WHERE MP.ORGANIZATION_CODE = EAI.ORGANIZATION_CODE))
11920: WHERE DATA_SET_ID = p_batch_id
11921: AND SOURCE_SYSTEM_ID = p_src_system_id
11922: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref

Line 11932: FROM MTL_PARAMETERS MP

11928: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
11929: SET ORGANIZATION_ID =
11930: NVL(ORGANIZATION_ID,
11931: (SELECT MP.ORGANIZATION_ID
11932: FROM MTL_PARAMETERS MP
11933: WHERE MP.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE))
11934: WHERE DATA_SET_ID = p_batch_id
11935: AND SOURCE_SYSTEM_ID = p_src_system_id
11936: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref

Line 12421: FROM MTL_PARAMETERS mp

12417: WHERE SET_PROCESS_ID = p_set_process_id
12418: AND EXISTS
12419: (
12420: SELECT NULL
12421: FROM MTL_PARAMETERS mp
12422: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12423: AND mp.ORGANIZATION_ID <> mp.MASTER_ORGANIZATION_ID
12424: AND ( (msii.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = msii.ORGANIZATION_ID)
12425: OR

Line 12455: FROM MTL_PARAMETERS mp

12451: WHERE SET_PROCESS_ID = p_set_process_id
12452: AND EXISTS
12453: (
12454: SELECT NULL
12455: FROM MTL_PARAMETERS mp
12456: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12457: AND ( (miri.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = miri.ORGANIZATION_ID)
12458: OR
12459: (miri.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = miri.ORGANIZATION_CODE)

Line 12494: FROM MTL_PARAMETERS mp

12490: WHERE bici.BATCH_ID = p_set_process_id
12491: AND EXISTS
12492: (
12493: SELECT NULL
12494: FROM MTL_PARAMETERS mp
12495: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12496: AND ( (bici.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = bici.ORGANIZATION_ID)
12497: OR
12498: (bici.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = bici.ORGANIZATION_CODE)

Line 12527: FROM MTL_PARAMETERS mp

12523: WHERE eipi.DATA_SET_ID = p_set_process_id
12524: AND EXISTS
12525: (
12526: SELECT NULL
12527: FROM MTL_PARAMETERS mp
12528: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12529: AND ( (eipi.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = eipi.ORGANIZATION_ID)
12530: OR
12531: (eipi.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = eipi.ORGANIZATION_CODE)

Line 12560: FROM MTL_PARAMETERS mp

12556: WHERE mici.SET_PROCESS_ID = p_set_process_id
12557: AND EXISTS
12558: (
12559: SELECT NULL
12560: FROM MTL_PARAMETERS mp
12561: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12562: AND ( (mici.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = mici.ORGANIZATION_ID)
12563: OR
12564: (mici.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = mici.ORGANIZATION_CODE)

Line 12593: FROM MTL_PARAMETERS mp

12589: WHERE eai.DATA_SET_ID = p_set_process_id
12590: AND EXISTS
12591: (
12592: SELECT NULL
12593: FROM MTL_PARAMETERS mp
12594: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12595: AND ( (eai.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = eai.ORGANIZATION_ID)
12596: OR
12597: (eai.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = eai.ORGANIZATION_CODE)

Line 12626: FROM MTL_PARAMETERS mp

12622: WHERE bcoi.BATCH_ID = p_set_process_id
12623: AND EXISTS
12624: (
12625: SELECT NULL
12626: FROM MTL_PARAMETERS mp
12627: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12628: AND ( (bcoi.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = bcoi.ORGANIZATION_ID)
12629: OR
12630: (bcoi.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = bcoi.ORGANIZATION_CODE)

Line 12659: FROM MTL_PARAMETERS mp

12655: WHERE brdi.BATCH_ID = p_set_process_id
12656: AND EXISTS
12657: (
12658: SELECT NULL
12659: FROM MTL_PARAMETERS mp
12660: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12661: AND ( (brdi.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = brdi.ORGANIZATION_ID)
12662: OR
12663: (brdi.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = brdi.ORGANIZATION_CODE)

Line 12692: FROM MTL_PARAMETERS mp

12688: WHERE bsci.BATCH_ID = p_set_process_id
12689: AND EXISTS
12690: (
12691: SELECT NULL
12692: FROM MTL_PARAMETERS mp
12693: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12694: AND ( (bsci.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = bsci.ORGANIZATION_ID)
12695: OR
12696: (bsci.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = bsci.ORGANIZATION_CODE)

Line 12731: FROM MTL_PARAMETERS mp

12727: WHERE bomi.BATCH_ID = p_set_process_id
12728: AND EXISTS
12729: (
12730: SELECT NULL
12731: FROM MTL_PARAMETERS mp
12732: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12733: AND ( (bomi.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = bomi.ORGANIZATION_ID)
12734: OR
12735: (bomi.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = bomi.ORGANIZATION_CODE)

Line 12765: FROM MTL_PARAMETERS mp

12761: AND eiai.DATA_LEVEL_ID = edlb.DATA_LEVEL_ID
12762: AND EXISTS
12763: (
12764: SELECT NULL
12765: FROM MTL_PARAMETERS mp
12766: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12767: AND ( (eiai.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = eiai.ORGANIZATION_ID)
12768: OR
12769: (eiai.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = eiai.ORGANIZATION_CODE)