DBA Data[Home] [Help]

APPS.BOM_IMPORT_PUB dependencies on MTL_SYSTEM_ITEMS_VL

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 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 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 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 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 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 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 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 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: );