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 284: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB

280: BEGIN
281:
282: SELECT item_number
283: INTO l_temp
284: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_vl MSIVL,mtl_parameters MP,bom_structures_b BSB
285: WHERE BBMI.batch_id = p_batch_id
286: AND BSB.bill_sequence_id = p_bill_seq_id
287: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5 )
288: 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 331: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

327: BEGIN
328: update
329: BOM_BILL_OF_MTLS_INTERFACE
330: set
331: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
332: where
333: transaction_id is null
334: and batch_id = p_batch_id
335: and process_flag = 1;

Line 340: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

336:
337: update
338: BOM_INVENTORY_COMPS_INTERFACE
339: set
340: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
341: where
342: transaction_id is null
343: and batch_id = p_batch_id
344: and process_flag = 1;

Line 349: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

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

Line 358: transaction_id = MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

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

Line 708: mtl_system_items_interface MSII

704: 'Exist'
705: INTO
706: l_dummy
707: FROM
708: mtl_system_items_interface MSII
709: WHERE
710: MSII.set_process_id = p_batch_id
711: AND ( (MSII.source_system_reference = p_ss_reference AND MSII.source_system_reference_desc = p_ss_desc )
712: OR(MSII.item_number = p_item_number AND MSII.description = p_item_desc)

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

939:
940: CURSOR Process_Header(l_batch_id IN NUMBER)
941: IS
942: SELECT MCR.inventory_item_id,MCR.organization_id,BBMI.source_system_reference,MSI.segment1
943: FROM bom_bill_of_mtls_interface BBMI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
944: WHERE BBMI.batch_id = l_batch_id
945: AND EIBB.batch_id = BBMI.batch_id
946: AND MCR.source_system_id = EIBB.source_system_id
947: AND MCR.cross_reference = BBMI.source_system_reference

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

953:
954: CURSOR Process_Comp(l_batch_id IN NUMBER)
955: IS
956: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
957: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
958: WHERE BICI.batch_id = l_batch_id
959: AND EIBB.batch_id = BICI.batch_id
960: AND MCR.source_system_id = EIBB.source_system_id
961: AND MCR.cross_reference = BICI.comp_source_system_reference

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

967:
968: CURSOR Process_Header_For_Comp
969: IS
970: SELECT MCR.inventory_item_id,MCR.organization_id,BICI.comp_source_system_reference,MSI.segment1
971: FROM bom_inventory_comps_interface BICI,mtl_cross_references MCR,ego_import_batches_b EIBB,mtl_system_items MSI
972: WHERE BICI.batch_id = p_batch_id
973: AND EIBB.batch_id = BICI.batch_id
974: AND MCR.source_system_id = EIBB.source_system_id
975: AND MCR.cross_reference = BICI.parent_source_system_reference

Line 1120: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII

1116: l_request_id NUMBER := nvl(FND_GLOBAL.conc_request_id,-1);
1117: CURSOR Process_Header
1118: IS
1119: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1120: FROM bom_bill_of_mtls_interface BBMI,mtl_system_items_interface MSII
1121: WHERE BBMI.batch_id = p_batch_id
1122: AND (BBMI.process_flag = 1 OR BBMI.process_flag = 5)
1123: AND MSII.set_process_id = BBMI.batch_id
1124: AND MSII.process_flag IN (0,1,7)

Line 1132: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1128:
1129: CURSOR Process_Comp
1130: IS
1131: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1132: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1133: WHERE BICI.batch_id = p_batch_id
1134: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1135: AND MSII.set_process_id = BICI.batch_id
1136: AND MSII.process_flag IN (0,1,7)

Line 1144: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII

1140:
1141: Cursor Process_Header_For_Comp
1142: IS
1143: SELECT MSII.inventory_item_id,MSII.organization_id,MSII.source_system_reference,MSII.item_number
1144: FROM bom_inventory_comps_interface BICI,mtl_system_items_interface MSII
1145: WHERE BICI.batch_id = p_batch_id
1146: AND (BICI.process_flag = 1 OR BICI.process_flag = 5)
1147: AND MSII.set_process_id = BICI.batch_id
1148: AND MSII.process_flag IN (0,1,7)

Line 1366: FROM mtl_system_items_vl

1362:
1363: IF l_item_id_table(i) IS NULL THEN
1364: SELECT inventory_item_id
1365: INTO l_item_id_table(i)
1366: FROM mtl_system_items_vl
1367: WHERE (concatenated_segments = l_header_rec_table(i) OR concatenated_segments = l_item_name_table(i))
1368: AND organization_id = l_org_id_table(i);
1369: END IF;
1370:

Line 1459: FROM mtl_system_items_vl

1455: BEGIN
1456: IF l_comp_table(j).component_item_id IS NULL THEN
1457: SELECT inventory_item_id
1458: INTO l_comp_table(j).component_item_id
1459: FROM mtl_system_items_vl
1460: WHERE concatenated_segments = l_comp_table(j).component_item_number
1461: AND organization_id = l_org_id_table(i);
1462: END IF;
1463: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1900: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

1896: LOOP
1897: 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))
1898: THEN
1899: Write_Debug('Inserting into Mtl_Interface for Header');
1900: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
1901: ( set_process_id
1902: , source_system_id
1903: , source_system_reference
1904: , SOURCE_SYSTEM_REFERENCE_DESC

Line 1960: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

1956: 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))
1957: THEN
1958: Write_Debug('Inserting into Mtl_Interface for Comps');
1959:
1960: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
1961: (
1962: set_process_id
1963: , source_system_id
1964: , source_system_reference

Line 3317: mtl_system_items_interface

3313: SELECT COUNT(*) INTO l_item_infcrows_exists FROM
3314: ( SELECT
3315: 'X'
3316: FROM
3317: mtl_system_items_interface
3318: WHERE EXISTS
3319: (SELECT
3320: process_flag
3321: FROM

Line 3322: mtl_system_items_interface

3318: WHERE EXISTS
3319: (SELECT
3320: process_flag
3321: FROM
3322: mtl_system_items_interface
3323: WHERE
3324: set_process_id = p_batch_id
3325: AND process_flag = 1
3326: UNION ALL

Line 3401: mtl_system_items_interface

3397: organization_id,
3398: confirm_status,
3399: process_flag
3400: FROM
3401: mtl_system_items_interface
3402: WHERE
3403: set_process_id = p_batch_id
3404: AND confirm_status IN ('US','UM','UN','EX');
3405:

Line 3414: mtl_system_items_interface

3410: organization_id,
3411: confirm_status,
3412: process_flag
3413: FROM
3414: mtl_system_items_interface
3415: WHERE
3416: set_process_id = p_batch_id
3417: AND confirm_status IN ('CC','CM','CN');
3418:

Line 3735: FROM mtl_system_items_kfv

3731: IF l_head_item_id_table(i) IS NULL
3732: THEN
3733: SELECT inventory_item_id
3734: INTO l_head_item_id_table(i)
3735: FROM mtl_system_items_kfv
3736: WHERE concatenated_segments = l_head_name_table(i)
3737: AND organization_id = l_org_id_table(i);
3738: END IF;
3739:

Line 3745: FROM mtl_system_items_vl

3741: IF l_head_name_table(i) IS NULL
3742: THEN
3743: SELECT concatenated_segments
3744: INTO l_head_name_table(i)
3745: FROM mtl_system_items_vl
3746: WHERE inventory_item_id = l_head_item_id_table(i)
3747: AND organization_id = l_org_id_table(i);
3748: END IF;
3749:

Line 3806: FROM mtl_system_items_kfv

3802: IF l_comp_item_id_table(i) IS NULL
3803: THEN
3804: SELECT inventory_item_id
3805: INTO l_comp_item_id_table(i)
3806: FROM mtl_system_items_kfv
3807: WHERE concatenated_segments = l_comp_name_table(i)
3808: AND organization_id = l_org_id_table(i);
3809: END IF;
3810:

Line 3815: FROM mtl_system_items_vl

3811: IF l_comp_name_table(i) IS NULL
3812: THEN
3813: SELECT concatenated_segments
3814: INTO l_comp_name_table(i)
3815: FROM mtl_system_items_vl
3816: WHERE inventory_item_id = l_comp_item_id_table(i)
3817: AND organization_id = l_org_id_table(i);
3818: END IF;
3819:

Line 3824: FROM mtl_system_items_kfv

3820: IF l_head_item_id_table(i) IS NULL
3821: THEN
3822: SELECT inventory_item_id
3823: INTO l_head_item_id_table(i)
3824: FROM mtl_system_items_kfv
3825: WHERE concatenated_segments = l_head_name_table(i)
3826: AND organization_id = l_org_id_table(i);
3827: END IF;
3828:

Line 3834: FROM mtl_system_items_vl

3830: IF l_head_name_table(i) IS NULL
3831: THEN
3832: SELECT concatenated_segments
3833: INTO l_head_name_table(i)
3834: FROM mtl_system_items_vl
3835: WHERE inventory_item_id = l_head_item_id_table(i)
3836: AND organization_id = l_org_id_table(i);
3837: END IF;
3838:

Line 3963: FROM mtl_system_items_interface

3959: FOR i IN 1..l_count
3960: LOOP
3961: SELECT inventory_item_id
3962: INTO l_item_id
3963: FROM mtl_system_items_interface
3964: WHERE set_process_id = p_batch_id
3965: AND source_system_reference = p_ssRef_varray(i);
3966:
3967: --Update the header

Line 4200: FROM mtl_system_items_vl

4196:
4197: IF l_item_id_table(i) IS NULL THEN
4198: SELECT inventory_item_id
4199: INTO l_item_id_table(i)
4200: FROM mtl_system_items_vl
4201: WHERE concatenated_segments = l_header_rec_table(i)
4202: AND organization_id = l_org_id_table(i);
4203: END IF;
4204:

Line 4239: FROM mtl_system_items_vl

4235: BEGIN
4236: IF l_comp_table(j).component_item_id IS NULL THEN
4237: SELECT inventory_item_id
4238: INTO l_comp_table(j).component_item_id
4239: FROM mtl_system_items_vl
4240: WHERE concatenated_segments = l_comp_table(j).comp_source_system_reference
4241: AND organization_id = l_org_id_table(i);
4242: END IF;
4243: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 4312: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL

4308: l_unmatch_comp(m).component_item_id,
4309: l_org_id_table(i),
4310: l_unmatch_comp(m).component_sequence_id,
4311: l_unmatch_comp(m).bill_sequence_id,
4312: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL
4313: WHERE MSIVL.inventory_item_id = l_comp_pdh_table(k).component_item_id
4314: AND organization_id = l_org_id_table(i)),
4315: p_batch_id,
4316: 'DELETE',

Line 4319: (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)),

4315: p_batch_id,
4316: 'DELETE',
4317: SYSDATE,
4318: 1,
4319: (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)),
4320: (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)),
4321: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4322: l_str_name(i),
4323: l_comp_pdh_table(k).component_item_id,

Line 4320: (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)),

4316: 'DELETE',
4317: SYSDATE,
4318: 1,
4319: (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)),
4320: (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)),
4321: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4322: l_str_name(i),
4323: l_comp_pdh_table(k).component_item_id,
4324: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

Line 4324: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4320: (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)),
4321: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4322: l_str_name(i),
4323: l_comp_pdh_table(k).component_item_id,
4324: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4325: );
4326:
4327: Disable_Refds
4328: (

Line 4453: (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)),

4449: p_batch_id,
4450: 'DELETE',
4451: SYSDATE,
4452: 1,
4453: (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)),
4454: (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)),
4455: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4456: l_str_name(i),
4457: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

Line 4454: (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)),

4450: 'DELETE',
4451: SYSDATE,
4452: 1,
4453: (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)),
4454: (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)),
4455: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4456: l_str_name(i),
4457: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4458: );

Line 4457: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4453: (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)),
4454: (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)),
4455: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4456: l_str_name(i),
4457: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4458: );
4459: END IF;
4460: Disable_Refds
4461: (

Line 4511: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL

4507: l_unmatch_comp(m).component_item_id,
4508: l_org_id_table(i),
4509: l_unmatch_comp(m).component_sequence_id,
4510: l_unmatch_comp(m).bill_sequence_id,
4511: (SELECT concatenated_segments FROM mtl_system_items_vl MSIVL
4512: WHERE MSIVL.inventory_item_id = l_comp_pdh_table(j).component_item_id
4513: AND organization_id = l_org_id_table(i)),
4514: p_batch_id,
4515: 'DELETE',

Line 4518: (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)),

4514: p_batch_id,
4515: 'DELETE',
4516: SYSDATE,
4517: 1,
4518: (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)),
4519: (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)),
4520: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4521: l_str_name(i),
4522: l_comp_pdh_table(j).component_item_id ,

Line 4519: (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)),

4515: 'DELETE',
4516: SYSDATE,
4517: 1,
4518: (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)),
4519: (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)),
4520: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4521: l_str_name(i),
4522: l_comp_pdh_table(j).component_item_id ,
4523: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

Line 4523: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4519: (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)),
4520: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4521: l_str_name(i),
4522: l_comp_pdh_table(j).component_item_id ,
4523: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4524: );
4525:
4526: Disable_Refds
4527: (

Line 4640: (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)),

4636: p_batch_id,
4637: 'DELETE',
4638: SYSDATE,
4639: 1,
4640: (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)),
4641: (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)),
4642: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4643: l_str_name(i),
4644: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

Line 4641: (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)),

4637: 'DELETE',
4638: SYSDATE,
4639: 1,
4640: (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)),
4641: (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)),
4642: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4643: l_str_name(i),
4644: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4645: );

Line 4644: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4640: (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)),
4641: (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)),
4642: (SELECT organization_code FROM mtl_parameters WHERE organization_id = l_org_id_table(i)),
4643: l_str_name(i),
4644: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4645: );
4646: END IF;
4647: Disable_Refds
4648: (

Line 4708: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

4704: IS
4705: L_NEXT_VALUE NUMBER;
4706: BEGIN
4707: SELECT
4708: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4709: INTO
4710: L_NEXT_VALUE
4711: FROM DUAL;
4712: RETURN L_NEXT_VALUE;