APPS.INVPOPIF dependencies on MTL_PARAMETERS

Line 212: ,mtl_parameters mp1

208:
209: CURSOR c_master_items(cp_transaction_type VARCHAR2) IS
210: SELECT COUNT(*)
211: FROM mtl_system_items_interface msii
212: ,mtl_parameters mp1
213: WHERE set_process_id = xset_id
214: AND transaction_type = cp_transaction_type
215: AND process_flag in (1,2,4)
216: AND mp1.master_organization_id = msii.organization_id

Line 222: ,mtl_parameters mp1

218:
219: CURSOR c_master_revs(cp_transaction_type VARCHAR2) IS
220: SELECT count(*)
221: FROM mtl_item_revisions_interface msii
222: ,mtl_parameters mp1
223: WHERE set_process_id = xset_id
224: AND transaction_type = cp_transaction_type
225: AND process_flag in (1,2,4)
226: AND mp1.master_organization_id = msii.organization_id

Line 239: FROM mtl_parameters)

235: AND transaction_type = cp_transaction_type
236: AND process_flag in (1,2,4)
237: AND organization_id
238: NOT IN (SELECT master_organization_id
239: FROM mtl_parameters)
240: AND ROWNUM = 1;
241:
242: CURSOR c_child_revs(cp_transaction_type VARCHAR2) IS
243: SELECT count(*)

Line 250: FROM mtl_parameters)

246: AND transaction_type = cp_transaction_type
247: AND process_flag in (1,2,4)
248: AND organization_id
249: NOT IN (SELECT master_organization_id
250: FROM mtl_parameters)
251: AND ROWNUM = 1;
252:
253: CURSOR c_interface_items(cp_transaction_type VARCHAR2) IS
254: SELECT count(*)

Line 366: from MTL_PARAMETERS MP

362:
363: update MTL_SYSTEM_ITEMS_INTERFACE MSII
364: set MSII.organization_id =
365: ( select MP.organization_id
366: from MTL_PARAMETERS MP
367: where MP.organization_code = MSII.organization_code
368: )
369: where MSII.organization_id is NULL
370: and MSII.set_process_id = xset_id

Line 388: from MTL_PARAMETERS MP

384:
385: update MTL_ITEM_REVISIONS_INTERFACE MIRI
386: set MIRI.organization_id =
387: ( select MP.organization_id
388: from MTL_PARAMETERS MP
389: where MP.organization_code = MIRI.organization_code
390: )
391: where MIRI.organization_id is NULL
392: and MIRI.set_process_id = xset_id

Line 466: FROM MTL_PARAMETERS PARAM

462: AND msii.process_flag = 1
463: AND msii.set_process_id = xset_id
464: AND msii.TRANSACTION_TYPE = 'CREATE'
465: AND EXISTS (SELECT NULL
466: FROM MTL_PARAMETERS PARAM
467: WHERE PARAM.ORGANIZATION_ID = MSII.ORGANIZATION_ID
468: AND PARAM.MASTER_ORGANIZATION_ID = PARAM.ORGANIZATION_ID)
469: AND 'Y' =
470: ( SELECT ICC.NEW_ITEM_REQUEST_REQD

Line 538: from mtl_parameters mp1

534: WHERE transaction_type = 'CREATE'
535: AND process_flag < 60000
536: AND set_process_id = xset_id
537: AND not exists (select mp1.organization_id
538: from mtl_parameters mp1
539: where msii.organization_id = mp1.master_organization_id);
540:
541: UPDATE mtl_item_revisions_interface miri
542: SET process_flag = process_flag + 60000

Line 547: from mtl_parameters mp1

543: WHERE transaction_type = 'CREATE'
544: AND process_flag < 60000
545: AND set_process_id = xset_id
546: AND not exists (select mp1.organization_id
547: from mtl_parameters mp1
548: where miri.organization_id = mp1.master_organization_id);
549:
550: --Creating Master Items
551: IF l_inv_debug_level IN(101, 102) THEN

Line 609: from mtl_parameters mp1

605: WHERE transaction_type = 'CREATE'
606: AND process_flag < 60000
607: AND set_process_id = xset_id
608: AND EXISTS (select mp1.organization_id /*BUG 6158936*/
609: from mtl_parameters mp1
610: where msii.organization_id = mp1.master_organization_id);
611:
612: UPDATE mtl_item_revisions_interface miri
613: SET process_flag = process_flag + 60000

Line 618: from mtl_parameters mp1

614: WHERE transaction_type = 'CREATE'
615: AND process_flag < 60000
616: AND set_process_id = xset_id
617: AND EXISTS (select mp1.organization_id /*BUG 6158936*/
618: from mtl_parameters mp1
619: where miri.organization_id = mp1.master_organization_id);
620:
621: IF l_inv_debug_level IN(101, 102) THEN
622: INVPUTLI.info('INVPOPIF all_org=1: Calling create process for childs');

Line 738: from mtl_parameters mp1

734: WHERE transaction_type = 'UPDATE'
735: AND process_flag < 60000
736: AND set_process_id = xset_id
737: AND not exists (select mp1.organization_id
738: from mtl_parameters mp1
739: where msii.organization_id = mp1.master_organization_id);
740:
741: UPDATE mtl_item_revisions_interface miri
742: SET process_flag = process_flag + 60000

Line 747: from mtl_parameters mp1

743: WHERE transaction_type = 'UPDATE'
744: AND process_flag < 60000
745: AND set_process_id = xset_id
746: AND not exists (select mp1.organization_id
747: from mtl_parameters mp1
748: where miri.organization_id = mp1.master_organization_id);
749:
750: --Update master Items.
751: ret_code_update := INVPOPIF.inopinp_OI_process_update (

Line 803: from mtl_parameters mp1

799: WHERE transaction_type = 'UPDATE'
800: AND process_flag < 60000
801: AND set_process_id = xset_id
802: AND not exists (select mp1.organization_id
803: from mtl_parameters mp1
804: where msii.organization_id <> mp1.master_organization_id);
805:
806: UPDATE mtl_item_revisions_interface miri
807: SET process_flag = process_flag + 60000

Line 812: from mtl_parameters mp1

808: WHERE transaction_type = 'UPDATE'
809: AND process_flag < 60000
810: AND set_process_id = xset_id
811: AND not exists (select mp1.organization_id
812: from mtl_parameters mp1
813: where miri.organization_id <> mp1.master_organization_id);
814:
815: --Updating the child records.
816: ret_code_update := INVPOPIF.inopinp_OI_process_update (

Line 1751: mtl_parameters mp

1747: SELECT 'Y' INTO l_child_records
1748: FROM DUAL
1749: WHERE EXISTS (SELECT NULL
1750: FROM mtl_system_items_interface msii,
1751: mtl_parameters mp
1752: WHERE transaction_type = 'CREATE'
1753: AND process_flag = 7
1754: AND set_process_id = xset_id
1755: AND msii.organization_id = mp.organization_id

Line 1975: FROM mtl_parameters

1971: l_masterOrg NUMBER;
1972: BEGIN
1973: SELECT 1
1974: INTO l_masterOrg
1975: FROM mtl_parameters
1976: WHERE master_organization_id = cp_orgid
1977: AND rownum = 1;
1978:
1979: return 1;