[Home] [Help]
389: WHERE process_flag = 1
390: AND set_process_id = xset_id
391: AND ((organization_id = org_id) or (all_org = 1))
392: AND organization_id IN (SELECT master_organization_id /*Bug 6158936*/
393: FROM mtl_parameters)
394: AND item_catalog_group_id IS NOT NULL ;
395:
396: IF catalog_table.COUNT > 0 THEN
397: FOR I IN catalog_table.FIRST .. catalog_table.LAST LOOP
406: AND msii.set_process_id = xset_id
407: AND nvl(msii.style_item_flag, 'N') <> 'Y' --Bug 6182208
408: AND ((msii.organization_id = org_id) or (all_org = 1))
409: AND msii.organization_id IN (SELECT master_organization_id /*Bug 6158936*/
410: FROM mtl_parameters)
411: AND (msii.item_catalog_group_id IS NOT NULL AND msii.item_catalog_group_id = catalog_table(i));
412:
413: IF l_inv_debug_level IN(101, 102) THEN
414: INVPUTLI.info('INVPAGI2: Identified rows for SEQ generation are:' || SQL%ROWCOUNT);
463: SET msii.process_flag = 3
464: WHERE msii.process_flag = 1
465: AND msii.transaction_type = 'CREATE'
466: AND msii.set_process_id = xset_id
467: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
468: WHERE mp.organization_id = msii.organization_id )
469: AND ( msii.style_item_flag = 'N' AND msii.style_item_id IS NULL AND msii.style_item_number IS NULL)
470: RETURNING transaction_id BULK COLLECT INTO transaction_table;
471:
493: FROM mtl_system_items_interface msii
494: WHERE msii.process_flag = 1
495: AND msii.transaction_type = 'CREATE'
496: AND msii.set_process_id = xset_id
497: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
498: WHERE mp.organization_id = msii.organization_id )
499: AND ( msii.style_item_flag = 'N' AND msii.style_item_id IS NULL AND msii.style_item_number IS NOT NULL);
500:
501: IF style_item_num_table.COUNT > 0 THEN
526: SET process_flag = 3
527: WHERE msii.process_flag = 1
528: AND msii.transaction_type = 'CREATE'
529: AND msii.set_process_id = xset_id
530: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
531: WHERE mp.organization_id = msii.organization_id )
532: AND msii.style_item_number = style_item_num_table(i);
533: ELSE
534: UPDATE mtl_system_items_interface msii
535: SET msii.style_item_id = l_style_item_id
536: WHERE msii.process_flag = 1
537: AND msii.transaction_type = 'CREATE'
538: AND msii.set_process_id = xset_id
539: AND msii.organization_id = (SELECT mp.master_organization_id FROM mtl_parameters mp
540: WHERE mp.organization_id = msii.organization_id )
541: AND msii.style_item_number = style_item_num_table(i);
542: END IF;
543: CLOSE c_get_style;
646: /* removed + 0 from where condition
647: and clause of organization_id to fix bug 7459820 with base bug 7003119 */
648: /*Bug 8808591 - Changing driving table according to Perf team suggestion*/
649: DSQL_statement := 'select msi.inventory_item_id
650: from mtl_parameters mp,
651: mtl_system_items msi,
652: mtl_system_items_interface msii
653:
654: where msii.transaction_id = :transaction_id_bind
663:
664:
665: update MTL_ITEM_REVISIONS_INTERFACE i
666: set i.organization_id = (select o.organization_id
667: from MTL_PARAMETERS o
668: where o.organization_code = i.organization_code)
669: where i.organization_id is NULL
670: and set_process_id = xset_id
671: and i.process_flag = l_process_flag_1;
872: where rowid = cr.rowid ;
873: begin
874: select organization_code
875: into org_code
876: from mtl_parameters
877: where organization_id = cr.organization_id;
878: exception
879: WHEN NO_DATA_FOUND then
880: org_flag := 1;
1008: DSQL_Statement_Msii := 'SELECT /*+ index(msii MTL_SYSTEM_ITEMS_INTERFACE_N6) index(msi MTL_SYSTEM_ITEMS_INTERFACE_N4) */ msi.inventory_item_id
1009: FROM mtl_system_items_interface msi, mtl_system_items_interface msii
1010: WHERE msi.set_process_id = msii.set_process_id
1011: AND msi.organization_id =
1012: (SELECT mp.master_organization_id FROM mtl_parameters mp
1013: WHERE mp.organization_id = msii.organization_id)
1014: AND msii.set_process_id = :set_id_bind2
1015: AND msii.transaction_id = :transaction_id_bind
1016: AND rownum = 1
1109: d_cost_of_sales_account,
1110: d_encumbrance_account,
1111: d_sales_account,
1112: d_expense_account
1113: from mtl_parameters mp
1114: where mp.organization_id = cr.organization_id;
1115: End if ;
1116:
1117: if (cr.revision is null) then