APPS.INVPAGI2 dependencies on MTL_PARAMETERS

Line 375: FROM mtl_parameters)

371: WHERE process_flag = 1
372: AND set_process_id = xset_id
373: AND ((organization_id = org_id) or (all_org = 1))
374: AND organization_id IN (SELECT master_organization_id /*Bug 6158936*/
375: FROM mtl_parameters)
376: AND item_catalog_group_id IS NOT NULL ;
377:
378: IF catalog_table.COUNT > 0 THEN
379: FOR I IN catalog_table.FIRST .. catalog_table.LAST LOOP

Line 392: FROM mtl_parameters)

388: AND msii.set_process_id = xset_id
389: AND nvl(msii.style_item_flag, 'N') <> 'Y' --Bug 6182208
390: AND ((msii.organization_id = org_id) or (all_org = 1))
391: AND msii.organization_id IN (SELECT master_organization_id /*Bug 6158936*/
392: FROM mtl_parameters)
393: AND (msii.item_catalog_group_id IS NOT NULL AND msii.item_catalog_group_id = catalog_table(i));
394:
395: IF l_inv_debug_level IN(101, 102) THEN
396: INVPUTLI.info('INVPAGI2: Identified rows for SEQ generation are:' || SQL%ROWCOUNT);

Line 449: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp

445: SET msii.process_flag = 3
446: WHERE msii.process_flag = 1
447: AND msii.transaction_type = 'CREATE'
448: AND msii.set_process_id = xset_id
449: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
450: WHERE mp.organization_id = msii.organization_id )
451: AND ( msii.style_item_flag = 'N' AND msii.style_item_id IS NULL AND msii.style_item_number IS NULL)
452: RETURNING transaction_id BULK COLLECT INTO transaction_table;
453:

Line 479: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp

475: FROM mtl_system_items_interface msii
476: WHERE msii.process_flag = 1
477: AND msii.transaction_type = 'CREATE'
478: AND msii.set_process_id = xset_id
479: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
480: WHERE mp.organization_id = msii.organization_id )
481: AND ( msii.style_item_flag = 'N' AND msii.style_item_id IS NULL AND msii.style_item_number IS NOT NULL);
482:
483: IF style_item_num_table.COUNT > 0 THEN

Line 512: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp

508: SET process_flag = 3
509: WHERE msii.process_flag = 1
510: AND msii.transaction_type = 'CREATE'
511: AND msii.set_process_id = xset_id
512: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
513: WHERE mp.organization_id = msii.organization_id )
514: AND msii.style_item_number = style_item_num_table(i);
515: ELSE
516: UPDATE mtl_system_items_interface msii

Line 521: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp

517: SET msii.style_item_id = l_style_item_id
518: WHERE msii.process_flag = 1
519: AND msii.transaction_type = 'CREATE'
520: AND msii.set_process_id = xset_id
521: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
522: WHERE mp.organization_id = msii.organization_id )
523: AND msii.style_item_number = style_item_num_table(i);
524: END IF;
525: CLOSE c_get_style;

Line 631: mtl_parameters mp

627:
628: DSQL_statement := 'select msi.inventory_item_id
629: from mtl_system_items msi,
630: mtl_system_items_interface msii,
631: mtl_parameters mp
632: where msii.transaction_id = :transaction_id_bind
633: and msii.set_process_id = :set_id_bind2
634: and rownum = 1
635: and msi.organization_id = mp.organization_id + 0

Line 645: from MTL_PARAMETERS o

641:
642:
643: update MTL_ITEM_REVISIONS_INTERFACE i
644: set i.organization_id = (select o.organization_id
645: from MTL_PARAMETERS o
646: where o.organization_code = i.organization_code)
647: where i.organization_id is NULL
648: and set_process_id = xset_id
649: and i.process_flag = l_process_flag_1;

Line 827: from mtl_parameters

823: where rowid = cr.rowid ;
824: begin
825: select organization_code
826: into org_code
827: from mtl_parameters
828: where organization_id = cr.organization_id;
829: exception
830: WHEN NO_DATA_FOUND then
831: org_flag := 1;

Line 953: (SELECT mp.master_organization_id FROM mtl_parameters mp

949: DSQL_Statement_Msii := 'SELECT msi.inventory_item_id
950: FROM mtl_system_items_interface msi, mtl_system_items_interface msii
951: WHERE msi.set_process_id = msii.set_process_id
952: AND msi.organization_id =
953: (SELECT mp.master_organization_id FROM mtl_parameters mp
954: WHERE mp.organization_id = msii.organization_id)
955: AND msii.set_process_id = :set_id_bind2
956: AND msii.transaction_id = :transaction_id_bind
957: AND rownum = 1

Line 1045: from mtl_parameters mp

1041: d_cost_of_sales_account,
1042: d_encumbrance_account,
1043: d_sales_account,
1044: d_expense_account
1045: from mtl_parameters mp
1046: where mp.organization_id = cr.organization_id;
1047: End if ;
1048:
1049: if (cr.revision is null) then