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.BOM_IMPORT_PUB dependencies on MTL_SYSTEM_ITEMS

Line 291: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB

287: BEGIN
288:
289: SELECT item_number
290: INTO l_temp
291: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB
292: WHERE BBMI.batch_id = p_batch_id
293: AND BSB.bill_sequence_id = p_bill_seq_id
294: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5 )
295: AND (( BBMI.request_id IS NOT NULL AND BBMI.request_id = p_request_id ) OR (BBMI.bundle_id IS NOT NULL AND BBMI.bundle_id = p_bundle_id))

Line 338: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

334: BEGIN
335: update
336: BOM_BILL_OF_MTLS_INTERFACE
337: set
338: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
339: where
340: transaction_id is null
341: and batch_id = p_batch_id
342: and process_flag = 1;

Line 347: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

343:
344: update
345: BOM_INVENTORY_COMPS_INTERFACE
346: set
347: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
348: where
349: transaction_id is null
350: and batch_id = p_batch_id
351: and process_flag = 1;

Line 356: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

352:
353: update
354: BOM_SUB_COMPS_INTERFACE
355: set
356: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
357: where
358: transaction_id is null
359: and batch_id = p_batch_id
360: and process_flag = 1;

Line 365: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

361:
362: update
363: BOM_REF_DESGS_INTERFACE
364: set
365: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
366: where
367: transaction_id is null
368: and batch_id = p_batch_id
369: and process_flag = 1;

Line 834: mtl_system_items_interface MSII

830: 'Exist'
831: INTO
832: l_dummy
833: FROM
834: mtl_system_items_interface MSII
835: WHERE
836: MSII.set_process_id = p_batch_id
837: AND ( (MSII.source_system_reference = p_ss_reference AND MSII.source_system_reference_desc = p_ss_desc )
838: OR(MSII.item_number = p_item_number AND MSII.description = p_item_desc)

Line 1084: FROM bom_bill_of_mtls_interface BBMI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

1080:
1081: CURSOR Process_Header(l_batch_id IN NUMBER)
1082: IS
1083: SELECT MCR.inventory_item_id,MCR.organization_id,BBMI.source_system_reference,MSI.segment1
1084: FROM bom_bill_of_mtls_interface BBMI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
1085: WHERE BBMI.batch_id = l_batch_id
1086: AND EIBB.batch_id = BBMI.batch_id
1087: AND MCR.source_system_id = EIBB.source_system_id
1088: AND MCR.cross_reference = BBMI.source_system_reference

Line 1098: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

1094:
1095: CURSOR Process_Comp(l_batch_id IN NUMBER)
1096: IS
1097: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
1098: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
1099: WHERE BICI.batch_id = l_batch_id
1100: AND EIBB.batch_id = BICI.batch_id
1101: AND MCR.source_system_id = EIBB.source_system_id
1102: AND MCR.cross_reference = BICI.comp_source_system_reference

Line 1112: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI

1108:
1109: CURSOR Process_Header_For_Comp
1110: IS
1111: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
1112: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
1113: WHERE BICI.batch_id = p_batch_id
1114: AND EIBB.batch_id = BICI.batch_id
1115: AND MCR.source_system_id = EIBB.source_system_id
1116: AND MCR.cross_reference = BICI.parent_source_system_reference

Line 1261: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII

1257: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);
1258: CURSOR Process_Header
1259: IS
1260: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1261: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII
1262: WHERE BBMI.batch_id = p_batch_id
1263: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5)
1264: AND MSII.set_process_id = BBMI.batch_id
1265: AND MSII.process_flag IN (0,1,7)

Line 1273: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1269:
1270: CURSOR Process_Comp
1271: IS
1272: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1273: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1274: WHERE BICI.batch_id = p_batch_id
1275: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1276: AND MSII.set_process_id = BICI.batch_id
1277: AND MSII.process_flag IN (0,1,7)

Line 1285: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1281:
1282: Cursor Process_Header_For_Comp
1283: IS
1284: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1285: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1286: WHERE BICI.batch_id = p_batch_id
1287: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1288: AND MSII.set_process_id = BICI.batch_id
1289: AND MSII.process_flag IN (0,1,7)

Line 1507: FROM mtl_system_items_vl

1503:
1504: IF l_item_id_table(i) IS NULL THEN
1505: SELECT inventory_item_id
1506: INTO l_item_id_table(i)
1507: FROM mtl_system_items_vl
1508: WHERE (concatenated_segments = l_header_rec_table(i) OR concatenated_segments = l_item_name_table(i))
1509: AND organization_id = l_org_id_table(i);
1510: END IF;
1511:

Line 1600: FROM mtl_system_items_vl

1596: BEGIN
1597: IF l_comp_table(j).component_item_id IS NULL THEN
1598: SELECT inventory_item_id
1599: INTO l_comp_table(j).component_item_id
1600: FROM mtl_system_items_vl
1601: WHERE concatenated_segments = l_comp_table(j).component_item_number
1602: AND organization_id = l_org_id_table(i);
1603: END IF;
1604: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2043: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

2039: LOOP
2040: IF NOT Item_Exist_In_Mtl_Intf(l_ss_ref_table(i),p_batch_id,l_org_code_table(i),l_item_number_table(i),l_ss_desc_table(i),l_item_desc_table(i),l_org_id_table(i))
2041: THEN
2042: Write_Debug('Inserting into Mtl_Interface for Header');
2043: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
2044: ( set_process_id
2045: , source_system_id
2046: , source_system_reference
2047: , SOURCE_SYSTEM_REFERENCE_DESC

Line 2103: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

2099: IF NOT Item_Exist_In_Mtl_Intf(l_ss_ref_table(i),p_batch_id,l_org_code_table(i),l_item_number_table(i),l_ss_desc_table(i),l_item_desc_table(i),l_org_id_table(i))
2100: THEN
2101: Write_Debug('Inserting into Mtl_Interface for Comps');
2102:
2103: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
2104: (
2105: set_process_id
2106: , source_system_id
2107: , source_system_reference

Line 3709: mtl_system_items_interface

3705: SELECT COUNT(*) INTO l_item_infcrows_exists FROM
3706: ( SELECT
3707: 'X'
3708: FROM
3709: mtl_system_items_interface
3710: WHERE EXISTS
3711: (SELECT
3712: process_flag
3713: FROM

Line 3714: mtl_system_items_interface

3710: WHERE EXISTS
3711: (SELECT
3712: process_flag
3713: FROM
3714: mtl_system_items_interface
3715: WHERE
3716: set_process_id = p_batch_id
3717: AND process_flag = 1
3718: UNION ALL

Line 3793: mtl_system_items_interface

3789: organization_id,
3790: confirm_status,
3791: process_flag
3792: FROM
3793: mtl_system_items_interface
3794: WHERE
3795: set_process_id = p_batch_id
3796: AND confirm_status IN ('US','UM','UN','EX');
3797:

Line 3806: mtl_system_items_interface

3802: organization_id,
3803: confirm_status,
3804: process_flag
3805: FROM
3806: mtl_system_items_interface
3807: WHERE
3808: set_process_id = p_batch_id
3809: AND confirm_status IN ('CC','CM','CN');
3810:

Line 4127: FROM mtl_system_items_kfv

4123: IF l_head_item_id_table(i) IS NULL
4124: THEN
4125: SELECT inventory_item_id
4126: INTO l_head_item_id_table(i)
4127: FROM mtl_system_items_kfv
4128: WHERE concatenated_segments = l_head_name_table(i)
4129: AND organization_id = l_org_id_table(i);
4130: END IF;
4131:

Line 4137: FROM mtl_system_items_vl

4133: IF l_head_name_table(i) IS NULL
4134: THEN
4135: SELECT concatenated_segments
4136: INTO l_head_name_table(i)
4137: FROM mtl_system_items_vl
4138: WHERE inventory_item_id = l_head_item_id_table(i)
4139: AND organization_id = l_org_id_table(i);
4140: END IF;
4141:

Line 4198: FROM mtl_system_items_kfv

4194: IF l_comp_item_id_table(i) IS NULL
4195: THEN
4196: SELECT inventory_item_id
4197: INTO l_comp_item_id_table(i)
4198: FROM mtl_system_items_kfv
4199: WHERE concatenated_segments = l_comp_name_table(i)
4200: AND organization_id = l_org_id_table(i);
4201: END IF;
4202:

Line 4207: FROM mtl_system_items_vl

4203: IF l_comp_name_table(i) IS NULL
4204: THEN
4205: SELECT concatenated_segments
4206: INTO l_comp_name_table(i)
4207: FROM mtl_system_items_vl
4208: WHERE inventory_item_id = l_comp_item_id_table(i)
4209: AND organization_id = l_org_id_table(i);
4210: END IF;
4211:

Line 4216: FROM mtl_system_items_kfv

4212: IF l_head_item_id_table(i) IS NULL
4213: THEN
4214: SELECT inventory_item_id
4215: INTO l_head_item_id_table(i)
4216: FROM mtl_system_items_kfv
4217: WHERE concatenated_segments = l_head_name_table(i)
4218: AND organization_id = l_org_id_table(i);
4219: END IF;
4220:

Line 4226: FROM mtl_system_items_vl

4222: IF l_head_name_table(i) IS NULL
4223: THEN
4224: SELECT concatenated_segments
4225: INTO l_head_name_table(i)
4226: FROM mtl_system_items_vl
4227: WHERE inventory_item_id = l_head_item_id_table(i)
4228: AND organization_id = l_org_id_table(i);
4229: END IF;
4230:

Line 4355: FROM mtl_system_items_interface

4351: FOR i IN 1..l_count
4352: LOOP
4353: SELECT inventory_item_id
4354: INTO l_item_id
4355: FROM mtl_system_items_interface
4356: WHERE set_process_id = p_batch_id
4357: AND source_system_reference = p_ssRef_varray(i);
4358:
4359: --Update the header

Line 4592: FROM mtl_system_items_vl

4588:
4589: IF l_item_id_table(i) IS NULL THEN
4590: SELECT inventory_item_id
4591: INTO l_item_id_table(i)
4592: FROM mtl_system_items_vl
4593: WHERE concatenated_segments = l_header_rec_table(i)
4594: AND organization_id = l_org_id_table(i);
4595: END IF;
4596:

Line 4631: FROM mtl_system_items_vl

4627: BEGIN
4628: IF l_comp_table(j).component_item_id IS NULL THEN
4629: SELECT inventory_item_id
4630: INTO l_comp_table(j).component_item_id
4631: FROM mtl_system_items_vl
4632: WHERE concatenated_segments = l_comp_table(j).comp_source_system_reference
4633: AND organization_id = l_org_id_table(i);
4634: END IF;
4635: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 4704: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL

4700: l_unmatch_comp(m).component_item_id,
4701: l_org_id_table(i),
4702: l_unmatch_comp(m).component_sequence_id,
4703: l_unmatch_comp(m).bill_sequence_id,
4704: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL
4705: WHERE MSIVL.inventory_item_id = l_comp_pdh_table(k).component_item_id
4706: AND organization_id = l_org_id_table(i)),
4707: p_batch_id,
4708: 'DELETE',

Line 4711: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),

4707: p_batch_id,
4708: 'DELETE',
4709: SYSDATE,
4710: 1,
4711: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),
4712: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4713: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4714: l_str_name(i),
4715: l_comp_pdh_table(k).component_item_id,

Line 4712: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),

4708: 'DELETE',
4709: SYSDATE,
4710: 1,
4711: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),
4712: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4713: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4714: l_str_name(i),
4715: l_comp_pdh_table(k).component_item_id,
4716: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

Line 4716: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4712: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4713: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4714: l_str_name(i),
4715: l_comp_pdh_table(k).component_item_id,
4716: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4717: );
4718:
4719: Disable_Refds
4720: (

Line 4845: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),

4841: p_batch_id,
4842: 'DELETE',
4843: SYSDATE,
4844: 1,
4845: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4846: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
4847: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4848: l_str_name(i),
4849: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

Line 4846: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),

4842: 'DELETE',
4843: SYSDATE,
4844: 1,
4845: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4846: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
4847: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4848: l_str_name(i),
4849: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4850: );

Line 4849: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4845: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(k).component_item_id AND organization_id = l_org_id_table(i)),
4846: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
4847: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4848: l_str_name(i),
4849: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4850: );
4851: END IF;
4852: Disable_Refds
4853: (

Line 4903: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL

4899: l_unmatch_comp(m).component_item_id,
4900: l_org_id_table(i),
4901: l_unmatch_comp(m).component_sequence_id,
4902: l_unmatch_comp(m).bill_sequence_id,
4903: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL
4904: WHERE MSIVL.inventory_item_id = l_comp_pdh_table(j).component_item_id
4905: AND organization_id = l_org_id_table(i)),
4906: p_batch_id,
4907: 'DELETE',

Line 4910: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),

4906: p_batch_id,
4907: 'DELETE',
4908: SYSDATE,
4909: 1,
4910: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),
4911: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
4912: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4913: l_str_name(i),
4914: l_comp_pdh_table(j).component_item_id ,

Line 4911: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),

4907: 'DELETE',
4908: SYSDATE,
4909: 1,
4910: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_unmatch_comp(m).component_item_id AND organization_id = l_org_id_table(i)),
4911: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
4912: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4913: l_str_name(i),
4914: l_comp_pdh_table(j).component_item_id ,
4915: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

Line 4915: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4911: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
4912: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4913: l_str_name(i),
4914: l_comp_pdh_table(j).component_item_id ,
4915: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4916: );
4917:
4918: Disable_Refds
4919: (

Line 5032: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),

5028: p_batch_id,
5029: 'DELETE',
5030: SYSDATE,
5031: 1,
5032: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
5033: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
5034: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
5035: l_str_name(i),
5036: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

Line 5033: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),

5029: 'DELETE',
5030: SYSDATE,
5031: 1,
5032: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
5033: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
5034: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
5035: l_str_name(i),
5036: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
5037: );

Line 5036: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

5032: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id =l_comp_pdh_table(j).component_item_id AND organization_id = l_org_id_table(i)),
5033: (SELECT concatenated_segments FROM mtl_system_items_vl WHERE inventory_item_id = l_item_id_table(i) AND organization_id = l_org_id_table(i)),
5034: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
5035: l_str_name(i),
5036: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
5037: );
5038: END IF;
5039: Disable_Refds
5040: (

Line 5100: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

5096: IS
5097: L_NEXT_VALUE NUMBER;
5098: BEGIN
5099: SELECT
5100: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
5101: INTO
5102: L_NEXT_VALUE
5103: FROM DUAL;
5104: RETURN L_NEXT_VALUE;