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 777: FROM MTL_PARAMETERS MP

773: SELECT MP.ORGANIZATION_ID,
774: BA.SOURCE_SYSTEM_ID
775: INTO l_org_id
776: , l_ss_id
777: FROM MTL_PARAMETERS MP
778: , EGO_IMPORT_BATCHES_B ba
779: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID
780: AND BA.BATCH_ID = p_batch_id;
781: EXCEPTION

Line 822: FROM MTL_PARAMETERS P

818: , ATTR_GROUP_INT_NAME
819: , ATTR_INT_NAME
820: , COALESCE( EIUAI.ORGANIZATION_ID,
821: ( SELECT ORGANIZATION_ID
822: FROM MTL_PARAMETERS P
823: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
824: ),
825: ( SELECT ORGANIZATION_ID
826: FROM MTL_ITEM_REVISIONS_B R

Line 846: FROM MTL_PARAMETERS P

842: , ATTR_GROUP_INT_NAME
843: , ATTR_INT_NAME
844: , COALESCE( EIUAI.ORGANIZATION_ID,
845: ( SELECT ORGANIZATION_ID
846: FROM MTL_PARAMETERS P
847: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
848: ),
849: ( SELECT ORGANIZATION_ID
850: FROM MTL_ITEM_REVISIONS_B R

Line 906: FROM MTL_PARAMETERS P

902: , ATTR_GROUP_INT_NAME
903: , ATTR_INT_NAME
904: , COALESCE( EIUAI.ORGANIZATION_ID,
905: ( SELECT ORGANIZATION_ID
906: FROM MTL_PARAMETERS P
907: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
908: ),
909: ( SELECT ORGANIZATION_ID
910: FROM MTL_ITEM_REVISIONS_B R

Line 931: FROM MTL_PARAMETERS P

927: , ATTR_GROUP_INT_NAME
928: , ATTR_INT_NAME
929: , COALESCE( EIUAI.ORGANIZATION_ID,
930: ( SELECT ORGANIZATION_ID
931: FROM MTL_PARAMETERS P
932: WHERE P.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE
933: ),
934: ( SELECT ORGANIZATION_ID
935: FROM MTL_ITEM_REVISIONS_B R

Line 1258: FROM MTL_PARAMETERS p

1254: , PK4_VALUE
1255: , PK5_VALUE
1256: , COALESCE ( eiuai.ORGANIZATION_ID
1257: , ( SELECT ORGANIZATION_ID
1258: FROM MTL_PARAMETERS p
1259: WHERE p.ORGANIZATION_CODE = eiuai.ORGANIZATION_CODE
1260: )
1261: , NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
1262: )

Line 1278: FROM MTL_PARAMETERS p

1274: , PK4_VALUE
1275: , PK5_VALUE
1276: , COALESCE ( eiuai.ORGANIZATION_ID
1277: , ( SELECT ORGANIZATION_ID
1278: FROM MTL_PARAMETERS p
1279: WHERE p.ORGANIZATION_CODE = eiuai.ORGANIZATION_CODE
1280: )
1281: , NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
1282: )

Line 1339: FROM MTL_PARAMETERS p

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

Line 1360: FROM MTL_PARAMETERS p

1356: , PK4_VALUE
1357: , PK5_VALUE
1358: , COALESCE ( eiuai.ORGANIZATION_ID
1359: , ( SELECT ORGANIZATION_ID
1360: FROM MTL_PARAMETERS p
1361: WHERE p.ORGANIZATION_CODE = eiuai.ORGANIZATION_CODE
1362: )
1363: , NVL2( ORGANIZATION_CODE, cp_master_org_id, NULL )
1364: )

Line 1745: FROM MTL_PARAMETERS mp

1741: )
1742: AND ITEM_NUMBER IS NOT NULL
1743: AND ORGANIZATION_ID IS NOT NULL
1744: AND EXISTS ( SELECT NULL
1745: FROM MTL_PARAMETERS mp
1746: WHERE mp.ORGANIZATION_ID = msii.ORGANIZATION_ID
1747: AND mp.MASTER_ORGANIZATION_ID = l_org_id
1748: )
1749: )

Line 1785: FROM MTL_PARAMETERS mp

1781: AND SOURCE_SYSTEM_ID = l_ss_id
1782: AND SOURCE_SYSTEM_REFERENCE IS NOT NULL
1783: AND ORGANIZATION_ID IS NOT NULL
1784: AND EXISTS ( SELECT NULL
1785: FROM MTL_PARAMETERS mp
1786: WHERE mp.ORGANIZATION_ID = msii.ORGANIZATION_ID
1787: AND mp.MASTER_ORGANIZATION_ID = l_org_id
1788: )
1789: )

Line 2540: FROM mtl_parameters mp

2536: and SOURCE_SYSTEM_ID = cp_ss_id
2537: and SOURCE_SYSTEM_REFERENCE IS NOT NULL
2538: AND ORGANIZATION_ID IS NOT NULL
2539: and EXISTS ( SELECT null
2540: FROM mtl_parameters mp
2541: WHERE mp.ORGANIZATION_ID = miri.ORGANIZATION_ID
2542: and mp.MASTER_ORGANIZATION_ID = cp_master_org_id
2543: )
2544: )

Line 2587: FROM mtl_parameters mp

2583: AND ( SOURCE_SYSTEM_ID IS NULL
2584: OR SOURCE_SYSTEM_ID = G_PDH_SOURCE_SYSTEM_ID
2585: )
2586: AND EXISTS ( SELECT null
2587: FROM mtl_parameters mp
2588: WHERE mp.organization_id = miri.organization_id
2589: AND mp.master_organization_id = cp_master_org_id
2590: )
2591: )

Line 3208: FROM MTL_PARAMETERS mp

3204: AND ITEM_NUMBER IS NOT NULL
3205: AND ORGANIZATION_ID IS NOT NULL
3206: AND EXISTS
3207: (SELECT NULL
3208: FROM MTL_PARAMETERS mp
3209: WHERE mp.ORGANIZATION_ID = msii.ORGANIZATION_ID
3210: AND mp.MASTER_ORGANIZATION_ID = l_org_id
3211: )
3212: ) sub

Line 3836: FROM MTL_PARAMETERS mp

3832: AND ORGANIZATION_ID IS NOT NULL
3833: AND REVISION IS NOT NULL
3834: AND EXISTS
3835: (SELECT NULL
3836: FROM MTL_PARAMETERS mp
3837: WHERE mp.ORGANIZATION_ID = miri.ORGANIZATION_ID
3838: AND mp.MASTER_ORGANIZATION_ID = p_master_org_id
3839: )
3840: ) sub

Line 4101: FROM MTL_PARAMETERS mp

4097: AND CATEGORY_SET_NAME IS NOT NULL
4098: AND CATEGORY_NAME IS NOT NULL
4099: AND EXISTS
4100: (SELECT NULL
4101: FROM MTL_PARAMETERS mp
4102: WHERE mp.ORGANIZATION_ID = mici.ORGANIZATION_ID
4103: AND mp.MASTER_ORGANIZATION_ID = p_master_org_id
4104: )
4105: ) sub

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

5991: p_status IN VARCHAR2,
5992: p_inventory_item_id IN NUMBER DEFAULT NULL,
5993: p_organization_id IN NUMBER DEFAULT NULL)
5994: IS
5995: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
5996: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
5997: unexpected_parameters EXCEPTION;
5998: BEGIN
5999: -- Check that the parameters satisfy the assumptions: if they don't, raise error

Line 5996: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

5992: p_inventory_item_id IN NUMBER DEFAULT NULL,
5993: p_organization_id IN NUMBER DEFAULT NULL)
5994: IS
5995: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
5996: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
5997: unexpected_parameters EXCEPTION;
5998: BEGIN
5999: -- Check that the parameters satisfy the assumptions: if they don't, raise error
6000:

Line 6024: FROM MTL_PARAMETERS MP,

6020: SELECT
6021: MP.ORGANIZATION_ID,
6022: MP.ORGANIZATION_CODE
6023: INTO l_org_id, l_org_code
6024: FROM MTL_PARAMETERS MP,
6025: EGO_IMPORT_BATCHES_B BA
6026: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND
6027: BA.BATCH_ID = p_data_set_id;
6028:

Line 6199: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;

6195: l_pdh_item_catalog_group_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
6196: l_confirm_status MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE;
6197: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6198: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6199: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6200: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6201: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
6202: l_instance_rev_policy MTL_SYSTEM_ITEMS_INTERFACE.REVISION_IMPORT_POLICY%TYPE;
6203: l_style_item_flag MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_FLAG%TYPE;

Line 6200: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

6196: l_confirm_status MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE;
6197: l_item_num_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_NUM_GEN_METHOD%TYPE;
6198: l_item_desc_gen MTL_ITEM_CATALOG_GROUPS_B.ITEM_DESC_GEN_METHOD%TYPE;
6199: l_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6200: l_organization_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6201: l_batch_rev_policy EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE;
6202: l_instance_rev_policy MTL_SYSTEM_ITEMS_INTERFACE.REVISION_IMPORT_POLICY%TYPE;
6203: l_style_item_flag MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_FLAG%TYPE;
6204: BEGIN

Line 6210: FROM MTL_PARAMETERS MP,

6206: MP.ORGANIZATION_ID,
6207: MP.ORGANIZATION_CODE,
6208: NVL(OPT.REVISION_IMPORT_POLICY, 'L')
6209: INTO l_organization_id, l_organization_code, l_batch_rev_policy
6210: FROM MTL_PARAMETERS MP,
6211: EGO_IMPORT_BATCHES_B ba,
6212: EGO_IMPORT_OPTION_SETS OPT
6213: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID AND
6214: BA.BATCH_ID = OPT.BATCH_ID AND

Line 6363: FROM mtl_parameters mp

6359: WHERE set_process_id = p_set_id
6360: AND process_flag = 0
6361: AND organization_id /*bug 6402904 parse for child items also*/
6362: IN (SELECT organization_id
6363: FROM mtl_parameters mp
6364: WHERE mp.master_organization_id = p_master_org_id)
6365: AND ( confirm_status IS NULL
6366: OR confirm_status = G_FAKE_CONF_STATUS_FLAG
6367: )

Line 6492: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;

6488: PROCEDURE Resolve_SSXref_on_Data_load( p_data_set_id IN NUMBER
6489: ,p_commit IN FLAG DEFAULT FND_API.G_TRUE
6490: )
6491: IS
6492: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6493: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6494: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_id%TYPE;
6495: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
6496: l_party_name VARCHAR2(1000);

Line 6493: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

6489: ,p_commit IN FLAG DEFAULT FND_API.G_TRUE
6490: )
6491: IS
6492: l_org_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE;
6493: l_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
6494: l_ss_id EGO_IMPORT_BATCHES_B.SOURCE_SYSTEM_id%TYPE;
6495: l_import_xref_only EGO_IMPORT_OPTION_SETS.IMPORT_XREF_ONLY%TYPE;
6496: l_party_name VARCHAR2(1000);
6497: l_security_predicate VARCHAR2(4000);

Line 6521: FROM MTL_PARAMETERS MP,

6517: BA.SOURCE_SYSTEM_ID,
6518: NVL(OPT.IMPORT_XREF_ONLY, 'N'),
6519: NVL(ENABLED_FOR_DATA_POOL, 'N')
6520: INTO l_org_id, l_org_code, l_ss_id, l_import_xref_only, l_enabled_for_data_pool
6521: FROM MTL_PARAMETERS MP,
6522: EGO_IMPORT_BATCHES_B BA,
6523: EGO_IMPORT_OPTION_SETS OPT
6524: WHERE BA.ORGANIZATION_ID = MP.ORGANIZATION_ID
6525: AND BA.BATCH_ID = p_data_set_id

Line 6534: FROM MTL_PARAMETERS mp, MTL_PARAMETERS mp1

6530: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
6531: BEGIN
6532: SELECT mp.MASTER_ORGANIZATION_ID, mp1.ORGANIZATION_CODE
6533: INTO l_org_id, l_org_code
6534: FROM MTL_PARAMETERS mp, MTL_PARAMETERS mp1
6535: WHERE mp.ORGANIZATION_ID = TO_NUMBER(l_org)
6536: AND mp.MASTER_ORGANIZATION_ID = mp1.ORGANIZATION_ID;
6537: EXCEPTION WHEN OTHERS THEN
6538: l_org_id := NULL;

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

6549: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
6550: SET ORGANIZATION_ID =
6551: CASE
6552: WHEN ORGANIZATION_CODE IS NOT NULL
6553: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MSII.ORGANIZATION_CODE)
6554: ELSE l_org_id
6555: END
6556: WHERE SET_PROCESS_ID = p_data_set_id AND
6557: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

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

6561: UPDATE MTL_ITEM_REVISIONS_INTERFACE MIRI
6562: SET ORGANIZATION_ID =
6563: CASE
6564: WHEN ORGANIZATION_CODE IS NOT NULL
6565: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MIRI.ORGANIZATION_CODE)
6566: ELSE l_org_id
6567: END
6568: WHERE SET_PROCESS_ID = p_data_set_id AND
6569: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

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

6573: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
6574: SET ORGANIZATION_ID =
6575: CASE
6576: WHEN ORGANIZATION_CODE IS NOT NULL
6577: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = MICI.ORGANIZATION_CODE)
6578: ELSE l_org_id
6579: END
6580: WHERE SET_PROCESS_ID = p_data_set_id AND
6581: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

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

6584: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
6585: SET ORGANIZATION_ID =
6586: CASE
6587: WHEN ORGANIZATION_CODE IS NOT NULL
6588: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE)
6589: ELSE l_org_id
6590: END
6591: WHERE DATA_SET_ID = p_data_set_id AND
6592: (PROCESS_STATUS IS NULL OR PROCESS_STATUS IN (0, 1)) AND

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

6595: UPDATE EGO_ITEM_PEOPLE_INTF EIPI
6596: SET ORGANIZATION_ID =
6597: CASE
6598: WHEN ORGANIZATION_CODE IS NOT NULL
6599: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIPI.ORGANIZATION_CODE)
6600: ELSE l_org_id
6601: END
6602: WHERE DATA_SET_ID = p_data_set_id AND
6603: (PROCESS_STATUS IS NULL OR PROCESS_STATUS IN (0, 1)) AND

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

6606: UPDATE EGO_AML_INTF EAI
6607: SET ORGANIZATION_ID =
6608: CASE
6609: WHEN ORGANIZATION_CODE IS NOT NULL
6610: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EAI.ORGANIZATION_CODE)
6611: ELSE l_org_id
6612: END
6613: WHERE DATA_SET_ID = p_data_set_id AND
6614: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

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

6617: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
6618: SET ORGANIZATION_ID =
6619: CASE
6620: WHEN ORGANIZATION_CODE IS NOT NULL
6621: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIAI.ORGANIZATION_CODE)
6622: ELSE l_org_id
6623: END
6624: WHERE BATCH_ID = p_data_set_id AND
6625: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND

Line 6853: -- , MTL_PARAMETERS MP

6849: , MAX( EIUAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6850: , MAX( EIUAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6851: , 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
6852: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
6853: -- , MTL_PARAMETERS MP
6854: WHERE
6855: data_set_id = p_data_set_id
6856: AND process_status = 1
6857: AND EIUAI.organization_id = l_org_id

Line 6887: -- , MTL_PARAMETERS MP

6883: , MAX( EAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
6884: , MAX( EAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6885: , MAX( EAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6886: FROM EGO_AML_INTF EAI
6887: -- , MTL_PARAMETERS MP
6888: WHERE
6889: EAI.data_set_id = p_data_set_id
6890: AND EAI.process_flag = 1
6891: AND EAI.organization_id = l_org_id

Line 7079: -- , MTL_PARAMETERS MP

7075: , 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
7076: , 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
7077: , 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
7078: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
7079: -- , MTL_PARAMETERS MP
7080: WHERE
7081: data_set_id = p_data_set_id
7082: AND process_status = 0
7083: AND EIUAI.organization_id = l_org_id

Line 7118: -- , MTL_PARAMETERS MP

7114: , 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
7115: , 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
7116: , 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
7117: FROM EGO_AML_INTF EAI
7118: -- , MTL_PARAMETERS MP
7119: WHERE
7120: EAI.data_set_id = p_data_set_id
7121: AND EAI.process_flag = 0
7122: AND EAI.organization_id = l_org_id

Line 8052: FROM MTL_PARAMETERS mp

8048: l_org := fnd_profile.value('EGO_USER_ORGANIZATION_CONTEXT');
8049: BEGIN
8050: SELECT mp.MASTER_ORGANIZATION_ID
8051: INTO l_org_id
8052: FROM MTL_PARAMETERS mp
8053: WHERE mp.ORGANIZATION_ID = TO_NUMBER(l_org);
8054: EXCEPTION WHEN OTHERS THEN
8055: l_org_id := NULL;
8056: END;

Line 8104: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp

8100: 'Y', 'Y'
8101: ),
8102: NVL(MAX(msik.STYLE_ITEM_ID), msii.STYLE_ITEM_ID),
8103: NVL(msii.INVENTORY_ITEM_ID, MAX(msik.INVENTORY_ITEM_ID))
8104: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp
8105: WHERE (msii.INVENTORY_ITEM_ID = msik.INVENTORY_ITEM_ID
8106: OR msii.ITEM_NUMBER = msik.CONCATENATED_SEGMENTS)
8107: AND msik.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
8108: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 8657: AND EXISTS (SELECT NULL FROM MTL_PARAMETERS mp

8653: )
8654: WHERE MSII.PROCESS_FLAG = 0
8655: AND MSII.CONFIRM_STATUS IS NULL
8656: AND MSII.SET_PROCESS_ID = p_data_set_id
8657: AND EXISTS (SELECT NULL FROM MTL_PARAMETERS mp
8658: WHERE mp.ORGANIZATION_ID = MSII.ORGANIZATION_ID
8659: AND mp.MASTER_ORGANIZATION_ID = l_org_id
8660: AND mp.MASTER_ORGANIZATION_ID <> mp.ORGANIZATION_ID
8661: )

Line 8822: FROM MTL_PARAMETERS

8818: AND ROWNUM = 1
8819: )
8820: WHEN '3'
8821: THEN (SELECT STARTING_REVISION
8822: FROM MTL_PARAMETERS
8823: WHERE ORGANIZATION_ID = ATTRS.ORGANIZATION_ID
8824: )
8825: END)
8826: WHERE ATTRS.PROCESS_STATUS = 1

Line 8875: FROM MTL_PARAMETERS

8871: AND MSII.SOURCE_SYSTEM_REFERENCE = MIRI.SOURCE_SYSTEM_REFERENCE
8872: AND MSII.ORGANIZATION_ID = l_org_id)
8873: )
8874: THEN (SELECT STARTING_REVISION
8875: FROM MTL_PARAMETERS
8876: WHERE ORGANIZATION_ID = MIRI.ORGANIZATION_ID
8877: )
8878: END) AS REVISION,
8879: 'SYNC' AS TRANSACTION_TYPE

Line 9038: FROM MTL_PARAMETERS MP

9034: WHERE MSII.SET_PROCESS_ID = :p_data_set_id
9035: AND MSII.PROCESS_FLAG = 0
9036: -- PICK ONLY CHILD ITEMS
9037: AND EXISTS (SELECT NULL
9038: FROM MTL_PARAMETERS MP
9039: WHERE MP.MASTER_ORGANIZATION_ID = :l_org_id
9040: AND MP.ORGANIZATION_ID <> MP.MASTER_ORGANIZATION_ID
9041: AND MP.ORGANIZATION_ID = MSII.ORGANIZATION_ID)
9042: -- CHILD MUST NOT HAVE A MASTER RECORD IN CURRENT BATCH

Line 9410: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp

9406: 'N', 'N',
9407: 'Y', 'Y'
9408: ),
9409: NVL(MAX(msik.STYLE_ITEM_ID), msii.STYLE_ITEM_ID)
9410: FROM MTL_SYSTEM_ITEMS_KFV msik, MTL_PARAMETERS mp
9411: WHERE (msii.INVENTORY_ITEM_ID = msik.INVENTORY_ITEM_ID
9412: OR msii.ITEM_NUMBER = msik.CONCATENATED_SEGMENTS)
9413: AND msik.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
9414: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID

Line 9625: FROM MTL_PARAMETERS MP

9621: AND PROCESS_FLAG = 3
9622: AND SET_PROCESS_ID = p_batch_id
9623: AND REQUEST_ID = l_request_id
9624: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9625: FROM MTL_PARAMETERS MP
9626: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9627: AND MP.ORGANIZATION_ID <> l_org_id
9628: );
9629: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );

Line 9643: FROM MTL_PARAMETERS MP

9639: AND PROCESS_FLAG = 3
9640: AND SET_PROCESS_ID = p_batch_id
9641: AND REQUEST_ID = l_request_id
9642: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9643: FROM MTL_PARAMETERS MP
9644: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9645: );
9646: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9647:

Line 9660: FROM MTL_PARAMETERS MP

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

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 9694: FROM MTL_PARAMETERS MP

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

Line 9711: FROM MTL_PARAMETERS MP

9707: AND PROCESS_FLAG = 3
9708: AND DATA_SET_ID = p_batch_id
9709: AND REQUEST_ID = l_request_id
9710: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9711: FROM MTL_PARAMETERS MP
9712: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9713: );
9714: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9715:

Line 9727: FROM MTL_PARAMETERS MP

9723: AND PROCESS_FLAG = 3
9724: AND BATCH_ID = p_batch_id
9725: AND REQUEST_ID = l_request_id
9726: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9727: FROM MTL_PARAMETERS MP
9728: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9729: );
9730: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9731: ELSE -- item id is null

Line 9740: FROM MTL_PARAMETERS MP

9736: AND PROCESS_FLAG = 3
9737: AND SET_PROCESS_ID = p_batch_id
9738: AND REQUEST_ID = l_request_id
9739: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9740: FROM MTL_PARAMETERS MP
9741: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9742: AND MP.ORGANIZATION_ID <> l_org_id
9743: );
9744: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );

Line 9754: FROM MTL_PARAMETERS MP

9750: AND PROCESS_FLAG = 3
9751: AND SET_PROCESS_ID = p_batch_id
9752: AND REQUEST_ID = l_request_id
9753: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9754: FROM MTL_PARAMETERS MP
9755: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9756: );
9757: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9758:

Line 9767: FROM MTL_PARAMETERS MP

9763: AND PROCESS_FLAG = 3
9764: AND SET_PROCESS_ID = p_batch_id
9765: AND REQUEST_ID = l_request_id
9766: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9767: FROM MTL_PARAMETERS MP
9768: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9769: );
9770: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9771:

Line 9780: FROM MTL_PARAMETERS MP

9776: AND PROCESS_STATUS = 3
9777: AND DATA_SET_ID = p_batch_id
9778: AND REQUEST_ID = l_request_id
9779: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9780: FROM MTL_PARAMETERS MP
9781: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9782: );
9783: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9784:

Line 9793: FROM MTL_PARAMETERS MP

9789: AND PROCESS_STATUS = 3
9790: AND DATA_SET_ID = p_batch_id
9791: AND REQUEST_ID = l_request_id
9792: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9793: FROM MTL_PARAMETERS MP
9794: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9795: );
9796: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9797:

Line 9806: FROM MTL_PARAMETERS MP

9802: AND PROCESS_FLAG = 3
9803: AND DATA_SET_ID = p_batch_id
9804: AND REQUEST_ID = l_request_id
9805: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9806: FROM MTL_PARAMETERS MP
9807: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9808: );
9809: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9810: -- updating item ITEM ASSOCIATIONS

Line 9818: FROM MTL_PARAMETERS MP

9814: AND PROCESS_FLAG = 3
9815: AND BATCH_ID = p_batch_id
9816: AND REQUEST_ID = l_request_id
9817: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
9818: FROM MTL_PARAMETERS MP
9819: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
9820: );
9821: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9822: END IF;

Line 9891: FROM MTL_PARAMETERS

9887:
9888: BEGIN
9889: SELECT ORGANIZATION_CODE
9890: INTO l_org_code
9891: FROM MTL_PARAMETERS
9892: WHERE ORGANIZATION_ID = l_org_id;
9893: EXCEPTION
9894: WHEN NO_DATA_FOUND THEN
9895: NULL;

Line 9999: FROM MTL_PARAMETERS MP

9995: AND PROCESS_FLAG = 3
9996: AND SET_PROCESS_ID = p_batch_id
9997: AND REQUEST_ID = l_request_id
9998: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID -- org assignment
9999: FROM MTL_PARAMETERS MP
10000: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
10001: AND MP.ORGANIZATION_ID <> l_org_id
10002: );
10003: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );

Line 10014: FROM MTL_PARAMETERS MP

10010: AND PROCESS_FLAG = 3
10011: AND SET_PROCESS_ID = p_batch_id
10012: AND REQUEST_ID = l_request_id
10013: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
10014: FROM MTL_PARAMETERS MP
10015: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
10016: );
10017: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10018:

Line 10028: FROM MTL_PARAMETERS MP

10024: AND PROCESS_FLAG = 3
10025: AND SET_PROCESS_ID = p_batch_id
10026: AND REQUEST_ID = l_request_id
10027: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
10028: FROM MTL_PARAMETERS MP
10029: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
10030: );
10031: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10032:

Line 10042: FROM MTL_PARAMETERS MP

10038: AND PROCESS_STATUS = 3
10039: AND DATA_SET_ID = p_batch_id
10040: AND REQUEST_ID = l_request_id
10041: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
10042: FROM MTL_PARAMETERS MP
10043: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
10044: );
10045: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10046:

Line 10056: FROM MTL_PARAMETERS MP

10052: AND PROCESS_STATUS = 3
10053: AND DATA_SET_ID = p_batch_id
10054: AND REQUEST_ID = l_request_id
10055: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
10056: FROM MTL_PARAMETERS MP
10057: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
10058: );
10059: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10060:

Line 10070: FROM MTL_PARAMETERS MP

10066: AND PROCESS_FLAG = 3
10067: AND DATA_SET_ID = p_batch_id
10068: AND REQUEST_ID = l_request_id
10069: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
10070: FROM MTL_PARAMETERS MP
10071: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
10072: );
10073: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10074: UPDATE EGO_ITEM_ASSOCIATIONS_INTF

Line 10082: FROM MTL_PARAMETERS MP

10078: AND PROCESS_FLAG = 3
10079: AND BATCH_ID = p_batch_id
10080: AND REQUEST_ID = l_request_id
10081: AND ORGANIZATION_ID IN ( SELECT MP.ORGANIZATION_ID
10082: FROM MTL_PARAMETERS MP
10083: WHERE MP.MASTER_ORGANIZATION_ID = l_org_id
10084: );
10085: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10086: END IF; -- IF l_is_ssxref_only

Line 12002: FROM MTL_PARAMETERS MP

11998: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
11999: SET ORGANIZATION_ID =
12000: NVL(ORGANIZATION_ID,
12001: (SELECT MP.ORGANIZATION_ID
12002: FROM MTL_PARAMETERS MP
12003: WHERE MP.ORGANIZATION_CODE = MSII.ORGANIZATION_CODE))
12004: ,ITEM_CATALOG_GROUP_ID =
12005: NVL(ITEM_CATALOG_GROUP_ID,
12006: (SELECT MICG.ITEM_CATALOG_GROUP_ID

Line 12021: FROM MTL_PARAMETERS MP

12017: UPDATE EGO_AML_INTF EAI
12018: SET ORGANIZATION_ID =
12019: NVL(ORGANIZATION_ID,
12020: (SELECT MP.ORGANIZATION_ID
12021: FROM MTL_PARAMETERS MP
12022: WHERE MP.ORGANIZATION_CODE = EAI.ORGANIZATION_CODE))
12023: WHERE DATA_SET_ID = p_batch_id
12024: AND SOURCE_SYSTEM_ID = p_src_system_id
12025: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref

Line 12035: FROM MTL_PARAMETERS MP

12031: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
12032: SET ORGANIZATION_ID =
12033: NVL(ORGANIZATION_ID,
12034: (SELECT MP.ORGANIZATION_ID
12035: FROM MTL_PARAMETERS MP
12036: WHERE MP.ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE))
12037: WHERE DATA_SET_ID = p_batch_id
12038: AND SOURCE_SYSTEM_ID = p_src_system_id
12039: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref

Line 12541: FROM MTL_PARAMETERS mp

12537: WHERE SET_PROCESS_ID = p_set_process_id
12538: AND EXISTS
12539: (
12540: SELECT NULL
12541: FROM MTL_PARAMETERS mp
12542: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12543: AND mp.ORGANIZATION_ID <> mp.MASTER_ORGANIZATION_ID
12544: AND ( (msii.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = msii.ORGANIZATION_ID)
12545: OR

Line 12575: FROM MTL_PARAMETERS mp

12571: WHERE SET_PROCESS_ID = p_set_process_id
12572: AND EXISTS
12573: (
12574: SELECT NULL
12575: FROM MTL_PARAMETERS mp
12576: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12577: AND ( (miri.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = miri.ORGANIZATION_ID)
12578: OR
12579: (miri.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = miri.ORGANIZATION_CODE)

Line 12614: FROM MTL_PARAMETERS mp

12610: WHERE bici.BATCH_ID = p_set_process_id
12611: AND EXISTS
12612: (
12613: SELECT NULL
12614: FROM MTL_PARAMETERS mp
12615: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12616: AND ( (bici.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = bici.ORGANIZATION_ID)
12617: OR
12618: (bici.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = bici.ORGANIZATION_CODE)

Line 12647: FROM MTL_PARAMETERS mp

12643: WHERE eipi.DATA_SET_ID = p_set_process_id
12644: AND EXISTS
12645: (
12646: SELECT NULL
12647: FROM MTL_PARAMETERS mp
12648: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12649: AND ( (eipi.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = eipi.ORGANIZATION_ID)
12650: OR
12651: (eipi.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = eipi.ORGANIZATION_CODE)

Line 12680: FROM MTL_PARAMETERS mp

12676: WHERE mici.SET_PROCESS_ID = p_set_process_id
12677: AND EXISTS
12678: (
12679: SELECT NULL
12680: FROM MTL_PARAMETERS mp
12681: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12682: AND ( (mici.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = mici.ORGANIZATION_ID)
12683: OR
12684: (mici.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = mici.ORGANIZATION_CODE)

Line 12713: FROM MTL_PARAMETERS mp

12709: WHERE eai.DATA_SET_ID = p_set_process_id
12710: AND EXISTS
12711: (
12712: SELECT NULL
12713: FROM MTL_PARAMETERS mp
12714: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12715: AND ( (eai.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = eai.ORGANIZATION_ID)
12716: OR
12717: (eai.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = eai.ORGANIZATION_CODE)

Line 12746: FROM MTL_PARAMETERS mp

12742: WHERE bcoi.BATCH_ID = p_set_process_id
12743: AND EXISTS
12744: (
12745: SELECT NULL
12746: FROM MTL_PARAMETERS mp
12747: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12748: AND ( (bcoi.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = bcoi.ORGANIZATION_ID)
12749: OR
12750: (bcoi.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = bcoi.ORGANIZATION_CODE)

Line 12779: FROM MTL_PARAMETERS mp

12775: WHERE brdi.BATCH_ID = p_set_process_id
12776: AND EXISTS
12777: (
12778: SELECT NULL
12779: FROM MTL_PARAMETERS mp
12780: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12781: AND ( (brdi.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = brdi.ORGANIZATION_ID)
12782: OR
12783: (brdi.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = brdi.ORGANIZATION_CODE)

Line 12812: FROM MTL_PARAMETERS mp

12808: WHERE bsci.BATCH_ID = p_set_process_id
12809: AND EXISTS
12810: (
12811: SELECT NULL
12812: FROM MTL_PARAMETERS mp
12813: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12814: AND ( (bsci.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = bsci.ORGANIZATION_ID)
12815: OR
12816: (bsci.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = bsci.ORGANIZATION_CODE)

Line 12851: FROM MTL_PARAMETERS mp

12847: WHERE bomi.BATCH_ID = p_set_process_id
12848: AND EXISTS
12849: (
12850: SELECT NULL
12851: FROM MTL_PARAMETERS mp
12852: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12853: AND ( (bomi.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = bomi.ORGANIZATION_ID)
12854: OR
12855: (bomi.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = bomi.ORGANIZATION_CODE)

Line 12885: FROM MTL_PARAMETERS mp

12881: AND eiai.DATA_LEVEL_ID = edlb.DATA_LEVEL_ID
12882: AND EXISTS
12883: (
12884: SELECT NULL
12885: FROM MTL_PARAMETERS mp
12886: WHERE mp.MASTER_ORGANIZATION_ID = p_organization_id
12887: AND ( (eiai.ORGANIZATION_ID IS NOT NULL AND mp.ORGANIZATION_ID = eiai.ORGANIZATION_ID)
12888: OR
12889: (eiai.ORGANIZATION_ID IS NULL AND mp.ORGANIZATION_CODE = eiai.ORGANIZATION_CODE)