DBA Data[Home] [Help]

APPS.BOMPCMBM dependencies on BOM_STRUCTURES_B

Line 243: FROM BOM_STRUCTURES_B

239:
240: /* Get bill_sequence_id */
241: SELECT bill_sequence_id,assembly_type
242: INTO l_bill_sequence_id,l_assembly_type
243: FROM BOM_STRUCTURES_B
244: WHERE organization_id = current_org_id
245: AND assembly_item_id = common_item_from
246: AND nvl(alternate_bom_designator,'NONE') = nvl(alternate,'NONE') ;
247:

Line 325: FROM BOM_STRUCTURES_B

321: IF (item_not_found = 0) THEN
322: IF (SCOPE = 2 OR SCOPE = 3) THEN
323: SELECT COUNT(*)
324: INTO l_bill_exists
325: FROM BOM_STRUCTURES_B
326: WHERE ASSEMBLY_ITEM_ID = common_item_from
327: AND ORGANIZATION_ID = t_org_code_list(I)
328: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
329: ELSIF (SCOPE = 1) THEN

Line 332: FROM BOM_STRUCTURES_B

328: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
329: ELSIF (SCOPE = 1) THEN
330: SELECT COUNT(*)
331: INTO l_bill_exists
332: FROM BOM_STRUCTURES_B
333: WHERE ASSEMBLY_ITEM_ID = common_item_to
334: AND ORGANIZATION_ID = common_org_to
335: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
336: END IF ;

Line 363: FROM BOM_STRUCTURES_B

359:
360: if (l_bill_exists = 1 and (scope = 2 or scope = 3)) then
361: SELECT common_bill_sequence_id, bill_sequence_id
362: INTO common_bill_seq_id, bill_seq_id
363: FROM BOM_STRUCTURES_B
364: WHERE ASSEMBLY_ITEM_ID = common_item_from
365: AND ORGANIZATION_ID = t_org_code_list(I)
366: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
367:

Line 371: FROM BOM_STRUCTURES_B

367:
368: elsif(l_bill_exists =1 and scope = 1) then
369: SELECT common_bill_sequence_id, bill_sequence_id
370: INTO common_bill_seq_id, bill_seq_id
371: FROM BOM_STRUCTURES_B
372: WHERE ASSEMBLY_ITEM_ID = common_item_to
373: AND ORGANIZATION_ID = common_org_to
374: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
375: End if;

Line 389: FROM BOM_STRUCTURES_B

385: If (((scope = 2 or scope = 3) and (t_org_code_list(I) <> current_org_id))
386: OR (scope = 1)) then
387: SELECT BILL_SEQUENCE_ID
388: INTO l_bill_seq_id
389: FROM BOM_STRUCTURES_B
390: WHERE ASSEMBLY_ITEM_ID = l_item_id
391: AND ORGANIZATION_ID = l_org_id
392: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
393:

Line 686: Update BOM_STRUCTURES_B

682: */
683: PROCEDURE Dereference_Header(p_bill_sequence_id NUMBER)
684: IS
685: BEGIN
686: Update BOM_STRUCTURES_B
687: Set source_bill_sequence_id = common_bill_Sequence_id,
688: common_bill_sequence_id = bill_sequence_id
689: Where bill_sequence_id = p_bill_sequence_id;
690: END;

Line 767: FROM BOM_STRUCTURES_B

763: IS
764: Cursor get_common_orgs(p_bill_seq_id NUMBER)
765: IS
766: SELECT distinct organization_id
767: FROM BOM_STRUCTURES_B
768: WHERE source_bill_sequence_id = p_bill_seq_id;
769:
770: l_comp_rev_id NUMBER;
771:

Line 818: from BOM_STRUCTURES_B

814:
815: Cursor get_structure_type(p_bill_seq_id NUMBER)
816: IS
817: SELECT structure_type_id
818: from BOM_STRUCTURES_B
819: where bill_sequence_id = p_bill_seq_id;
820: default_wip_params NUMBER;
821:
822: Cursor get_dest_components(p_src_comp_seq_id IN NUMBER, p_dest_bill_sequence_id IN NUMBER)

Line 862: from BOM_STRUCTURES_B

858: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);
859: --arudresh_debug('BOM:DEFAULT_WIP_VALUES'|| default_wip_params);
860: SELECT assembly_item_id, organization_id, alternate_bom_designator, effectivity_control
861: into l_assy_item_id, l_dest_org_id, l_alt_bom_desg, l_effectivity_ctrl
862: from BOM_STRUCTURES_B
863: where bill_sequence_id = p_dest_bill_sequence_id;
864:
865: IF l_effectivity_ctrl in (2,3,4)
866: THEN

Line 1089: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom

1085: , comp_rec.from_minor_revision_id
1086: , comp_rec.component_sequence_id
1087: , comp_rec.basis_type
1088: , decode(comp_rec.component_item_revision_id, null, null, BOMPCMBM.get_rev_id_for_local_org(comp_rec.component_item_revision_id, l_dest_org_id))
1089: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom
1090: WHERE comp_rec.bill_sequence_id = p_src_bill_sequence_id
1091: AND bom.bill_sequence_id = comp_rec.bill_sequence_id
1092: AND comp_rec.COMPONENT_ITEM_ID = item.inventory_item_id
1093: AND item.organization_id = l_dest_org_id

Line 1253: from BOM_STRUCTURES_B

1249: )
1250: IS
1251: Cursor get_related_bills(p_src_bill_sequence_id NUMBER) IS
1252: Select *
1253: from BOM_STRUCTURES_B
1254: where source_bill_sequence_id <> common_bill_sequence_id
1255: and source_bill_sequence_id = p_src_bill_sequence_id;
1256:
1257: Cursor get_src_comp_details(p_src_comp_seq_id NUMBER) IS

Line 1608: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1604: and organization_id = l_dest_org_id;
1605:
1606: SELECT concatenated_segments
1607: into l_dest_assy_item
1608: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1609: where item.inventory_item_id = bom.assembly_item_id
1610: and item.organization_id = bom.organization_id
1611: and bom.bill_sequence_id = src_comp_details.bill_sequence_id;
1612:

Line 1661: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1657: and organization_id = l_dest_org_id;
1658:
1659: SELECT concatenated_segments
1660: into l_dest_assy_item
1661: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1662: where item.inventory_item_id = bom.assembly_item_id
1663: and item.organization_id = bom.organization_id
1664: and bom.bill_sequence_id = src_comp_details.bill_sequence_id;
1665:

Line 1944: FROM BOM_STRUCTURES_B

1940: x_Return_Status := FND_API.G_RET_STS_ERROR;
1941:
1942: SELECT Organization_id
1943: INTO l_dest_org_id
1944: FROM BOM_STRUCTURES_B
1945: WHERE bill_sequence_id = dest_comp.bill_sequence_id;
1946:
1947: SELECT concatenated_segments
1948: into l_comp_name

Line 1955: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1951: and organization_id = l_dest_org_id;
1952:
1953: SELECT concatenated_segments
1954: into l_dest_assy_item
1955: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1956: where item.inventory_item_id = bom.assembly_item_id
1957: and item.organization_id = bom.organization_id
1958: and bom.bill_sequence_id = src_comp.bill_sequence_id;
1959:

Line 2008: FROM BOM_STRUCTURES_B

2004: x_Return_Status := FND_API.G_RET_STS_ERROR;
2005:
2006: SELECT Organization_id
2007: INTO l_dest_org_id
2008: FROM BOM_STRUCTURES_B
2009: WHERE bill_sequence_id = dest_comp.bill_sequence_id;
2010:
2011: SELECT concatenated_segments
2012: into l_comp_name

Line 2019: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

2015: and organization_id = l_dest_org_id;
2016:
2017: SELECT concatenated_segments
2018: into l_dest_assy_item
2019: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
2020: where item.inventory_item_id = bom.assembly_item_id
2021: and item.organization_id = bom.organization_id
2022: and bom.bill_sequence_id = src_comp.bill_sequence_id;
2023:

Line 3042: FROM bom_operational_routings bor, bom_operation_sequences bos, BOM_STRUCTURES_B bom

3038: WHERE bco.component_sequence_id = bic.component_sequence_id
3039: AND bic.component_sequence_id = p_component_sequence_id
3040: AND EXISTS(
3041: SELECT operation_seq_num, bos.routing_sequence_id
3042: FROM bom_operational_routings bor, bom_operation_sequences bos, BOM_STRUCTURES_B bom
3043: WHERE bos.routing_sequence_id = bor.common_routing_sequence_id
3044: AND bos.operation_seq_num = bco.operation_seq_num
3045: AND bor.assembly_item_id = bom.assembly_item_id
3046: AND bor.organization_id = bom.ORGANIZATION_id

Line 3482: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

3478:
3479: /* Cursor check_src_routing_exists(p_src_bill_sequence_id NUMBER)
3480: IS
3481: Select 'Routing Exists'
3482: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3483: Where bom.assembly_item_id = bor.assembly_item_id
3484: And bom.organization_id = bor.organizatin_id
3485: And nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3486: And bom.bill_sequence_id = p_src_bill_sequence_id*/

Line 3538: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

3534: --Check if Routing exists for the source bom
3535: BEGIN
3536: Select 'Routing Exists'
3537: INTO l_rtg_exist
3538: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3539: Where bom.assembly_item_id = bor.assembly_item_id
3540: And bom.organization_id = bor.organization_id
3541: And (nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3542: OR bor.alternate_routing_designator IS NULL)

Line 3637: from BOM_STRUCTURES_B

3633:
3634: Cursor get_structure_type(p_bill_seq_id NUMBER)
3635: IS
3636: Select structure_type_id
3637: from BOM_STRUCTURES_B
3638: where bill_sequence_id = p_bill_seq_id;
3639:
3640: BEGIN
3641:

Line 3730: FROM BOM_COMPONENTS_B bcb, BOM_STRUCTURES_B bsb

3726:
3727: Cursor get_dest_comps(p_src_comp_seq_id NUMBER, p_str_type_id NUMBER)
3728: IS
3729: SELECT bcb.component_sequence_id, bcb.bill_sequence_id
3730: FROM BOM_COMPONENTS_B bcb, BOM_STRUCTURES_B bsb
3731: WHERE bcb.common_component_sequence_id = p_src_comp_seq_id
3732: AND bcb.common_component_sequence_id <> bcb.component_sequence_id
3733: AND bsb.structure_type_id = p_str_type_id
3734: AND bsb.bill_sequence_id = bcb.bill_sequence_id

Line 3740: FROM BOM_STRUCTURES_B

3736:
3737: Cursor get_structure_type(p_bill_seq_id NUMBER)
3738: IS
3739: SELECT structure_type_id
3740: FROM BOM_STRUCTURES_B
3741: WHERE bill_sequence_id = p_bill_seq_id;
3742:
3743: Cursor Get_Attribute_Groups(p_component_seq_id NUMBER, p_bill_seq_id NUMBER)
3744: IS

Line 3856: from BOM_STRUCTURES_B

3852: IS
3853:
3854: Cursor get_related_bills(p_src_bill_sequence_id NUMBER) IS
3855: Select bill_sequence_id, organization_id, assembly_item_id, alternate_bom_designator
3856: from BOM_STRUCTURES_B
3857: where source_bill_sequence_id <> common_bill_sequence_id
3858: and source_bill_sequence_id = p_src_bill_sequence_id;
3859:
3860:

Line 3885: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

3881:
3882: BEGIN
3883: Select 'Routing Exists'
3884: INTO l_rtg_exist
3885: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3886: Where bom.assembly_item_id = bor.assembly_item_id
3887: And bom.organization_id = bor.organization_id
3888: And (nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3889: OR bor.alternate_routing_designator IS NULL

Line 4551: FROM bom_structures_b

4547: RETURN VARCHAR2
4548: IS
4549: CURSOR get_orgs IS
4550: SELECT DISTINCT organization_id
4551: FROM bom_structures_b
4552: WHERE source_bill_Sequence_id = p_src_bill_seq_id;
4553:
4554: BEGIN
4555: FOR org IN get_orgs