APPS.INVPOPIF dependencies on MTL_PARAMETERS

Line 225: ,mtl_parameters mp1

221:
222: CURSOR c_master_items(cp_transaction_type VARCHAR2) IS
223: SELECT COUNT(*)
224: FROM mtl_system_items_interface msii
225: ,mtl_parameters mp1
226: WHERE set_process_id = xset_id
227: AND transaction_type = cp_transaction_type
228: AND process_flag in (1,2,4)
229: AND mp1.master_organization_id = msii.organization_id

Line 235: ,mtl_parameters mp1

231:
232: CURSOR c_master_revs(cp_transaction_type VARCHAR2) IS
233: SELECT count(*)
234: FROM mtl_item_revisions_interface msii
235: ,mtl_parameters mp1
236: WHERE set_process_id = xset_id
237: AND transaction_type = cp_transaction_type
238: AND process_flag in (1,2,4)
239: AND mp1.master_organization_id = msii.organization_id

Line 252: FROM mtl_parameters)

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

Line 263: FROM mtl_parameters)

259: AND transaction_type = cp_transaction_type
260: AND process_flag in (1,2,4)
261: AND organization_id
262: NOT IN (SELECT master_organization_id
263: FROM mtl_parameters)
264: AND ROWNUM = 1;
265:
266: CURSOR c_interface_items(cp_transaction_type VARCHAR2) IS
267: SELECT count(*)

Line 471: from MTL_PARAMETERS MP

467:
468: update MTL_SYSTEM_ITEMS_INTERFACE MSII
469: set MSII.organization_id =
470: ( select MP.organization_id
471: from MTL_PARAMETERS MP
472: where MP.organization_code = MSII.organization_code
473: )
474: where MSII.organization_id is NULL
475: and MSII.set_process_id = xset_id

Line 493: from MTL_PARAMETERS MP

489:
490: update MTL_ITEM_REVISIONS_INTERFACE MIRI
491: set MIRI.organization_id =
492: ( select MP.organization_id
493: from MTL_PARAMETERS MP
494: where MP.organization_code = MIRI.organization_code
495: )
496: where MIRI.organization_id is NULL
497: and MIRI.set_process_id = xset_id

Line 631: FROM MTL_PARAMETERS PARAM

627: AND msii.process_flag = 1
628: AND msii.set_process_id = xset_id
629: AND msii.TRANSACTION_TYPE = 'CREATE'
630: AND EXISTS (SELECT NULL
631: FROM MTL_PARAMETERS PARAM
632: WHERE PARAM.ORGANIZATION_ID = MSII.ORGANIZATION_ID
633: AND PARAM.MASTER_ORGANIZATION_ID = PARAM.ORGANIZATION_ID)
634: AND 'Y' =
635: ( SELECT ICC.NEW_ITEM_REQUEST_REQD

Line 707: from mtl_parameters mp1

703: WHERE transaction_type = 'CREATE'
704: AND process_flag < 60000
705: AND set_process_id = xset_id
706: AND not exists (select mp1.organization_id
707: from mtl_parameters mp1
708: where msii.organization_id = mp1.master_organization_id);
709:
710: UPDATE mtl_item_revisions_interface miri
711: SET process_flag = process_flag + 60000

Line 716: from mtl_parameters mp1

712: WHERE transaction_type = 'CREATE'
713: AND process_flag < 60000
714: AND set_process_id = xset_id
715: AND not exists (select mp1.organization_id
716: from mtl_parameters mp1
717: where miri.organization_id = mp1.master_organization_id);
718:
719: --Creating Master Items
720: IF l_inv_debug_level IN(101, 102) THEN

Line 779: from mtl_parameters mp1

775: WHERE transaction_type = 'CREATE'
776: AND process_flag < 60000
777: AND set_process_id = xset_id
778: AND EXISTS (select mp1.organization_id /*BUG 6158936*/
779: from mtl_parameters mp1
780: where msii.organization_id = mp1.master_organization_id);
781:
782: UPDATE mtl_item_revisions_interface miri
783: SET process_flag = process_flag + 60000

Line 788: from mtl_parameters mp1

784: WHERE transaction_type = 'CREATE'
785: AND process_flag < 60000
786: AND set_process_id = xset_id
787: AND EXISTS (select mp1.organization_id /*BUG 6158936*/
788: from mtl_parameters mp1
789: where miri.organization_id = mp1.master_organization_id);
790:
791: IF l_inv_debug_level IN(101, 102) THEN
792: INVPUTLI.info('INVPOPIF all_org=1: Calling create process for childs');

Line 910: from mtl_parameters mp1

906: WHERE transaction_type = 'UPDATE'
907: AND process_flag < 60000
908: AND set_process_id = xset_id
909: AND not exists (select mp1.organization_id
910: from mtl_parameters mp1
911: where msii.organization_id = mp1.master_organization_id);
912:
913: UPDATE mtl_item_revisions_interface miri
914: SET process_flag = process_flag + 60000

Line 919: from mtl_parameters mp1

915: WHERE transaction_type = 'UPDATE'
916: AND process_flag < 60000
917: AND set_process_id = xset_id
918: AND not exists (select mp1.organization_id
919: from mtl_parameters mp1
920: where miri.organization_id = mp1.master_organization_id);
921:
922: --Update master Items.
923: ret_code_update := INVPOPIF.inopinp_OI_process_update (

Line 976: from mtl_parameters mp1

972: WHERE transaction_type = 'UPDATE'
973: AND process_flag < 60000
974: AND set_process_id = xset_id
975: AND not exists (select mp1.organization_id
976: from mtl_parameters mp1
977: where msii.organization_id <> mp1.master_organization_id);
978:
979: UPDATE mtl_item_revisions_interface miri
980: SET process_flag = process_flag + 60000

Line 985: from mtl_parameters mp1

981: WHERE transaction_type = 'UPDATE'
982: AND process_flag < 60000
983: AND set_process_id = xset_id
984: AND not exists (select mp1.organization_id
985: from mtl_parameters mp1
986: where miri.organization_id <> mp1.master_organization_id);
987:
988: --Updating the child records.
989: ret_code_update := INVPOPIF.inopinp_OI_process_update (

Line 1975: mtl_parameters mp

1971: SELECT 'Y' INTO l_child_records
1972: FROM DUAL
1973: WHERE EXISTS (SELECT NULL
1974: FROM mtl_system_items_interface msii,
1975: mtl_parameters mp
1976: WHERE transaction_type = 'CREATE'
1977: AND process_flag = 7
1978: AND set_process_id = xset_id
1979: AND msii.organization_id = mp.organization_id

Line 2199: FROM mtl_parameters

2195: l_masterOrg NUMBER;
2196: BEGIN
2197: SELECT 1
2198: INTO l_masterOrg
2199: FROM mtl_parameters
2200: WHERE master_organization_id = cp_orgid
2201: AND rownum = 1;
2202:
2203: return 1;