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.

[Home] [Help]

APPS.BOMPCMBM dependencies on BOM_STRUCTURES_B

Line 122: * Added for bug 11895331. This Procedure updates the bom_structures_b.request_id column

118: END Event_Acknowledgement;
119: -- ERES change ends
120:
121: /*
122: * Added for bug 11895331. This Procedure updates the bom_structures_b.request_id column
123: * to original value after Common Bom process completes either successfully or
124: * with exception.
125: * Explicit commit is required, so that other ECO implementation process will be allowed
126: * to progress on the same revised item. Autonomous Transaction is not required as

Line 341: FROM BOM_STRUCTURES_B

337:
338: /* Get bill_sequence_id */
339: SELECT bill_sequence_id,assembly_type
340: INTO l_bill_sequence_id,l_assembly_type
341: FROM BOM_STRUCTURES_B
342: WHERE organization_id = current_org_id
343: AND assembly_item_id = common_item_from
344: AND nvl(alternate_bom_designator,'NONE') = nvl(alternate,'NONE') ;
345:

Line 423: FROM BOM_STRUCTURES_B

419: IF (item_not_found = 0) THEN
420: IF (SCOPE = 2 OR SCOPE = 3) THEN
421: SELECT COUNT(*)
422: INTO l_bill_exists
423: FROM BOM_STRUCTURES_B
424: WHERE ASSEMBLY_ITEM_ID = common_item_from
425: AND ORGANIZATION_ID = t_org_code_list(I)
426: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
427: ELSIF (SCOPE = 1) THEN

Line 430: FROM BOM_STRUCTURES_B

426: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
427: ELSIF (SCOPE = 1) THEN
428: SELECT COUNT(*)
429: INTO l_bill_exists
430: FROM BOM_STRUCTURES_B
431: WHERE ASSEMBLY_ITEM_ID = common_item_to
432: AND ORGANIZATION_ID = common_org_to
433: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
434: END IF ;

Line 461: FROM BOM_STRUCTURES_B

457:
458: if (l_bill_exists = 1 and (scope = 2 or scope = 3)) then
459: SELECT common_bill_sequence_id, bill_sequence_id
460: INTO common_bill_seq_id, bill_seq_id
461: FROM BOM_STRUCTURES_B
462: WHERE ASSEMBLY_ITEM_ID = common_item_from
463: AND ORGANIZATION_ID = t_org_code_list(I)
464: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
465:

Line 469: FROM BOM_STRUCTURES_B

465:
466: elsif(l_bill_exists =1 and scope = 1) then
467: SELECT common_bill_sequence_id, bill_sequence_id
468: INTO common_bill_seq_id, bill_seq_id
469: FROM BOM_STRUCTURES_B
470: WHERE ASSEMBLY_ITEM_ID = common_item_to
471: AND ORGANIZATION_ID = common_org_to
472: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
473: End if;

Line 487: FROM BOM_STRUCTURES_B

483: If (((scope = 2 or scope = 3) and (t_org_code_list(I) <> current_org_id))
484: OR (scope = 1)) then
485: SELECT BILL_SEQUENCE_ID
486: INTO l_bill_seq_id
487: FROM BOM_STRUCTURES_B
488: WHERE ASSEMBLY_ITEM_ID = l_item_id
489: AND ORGANIZATION_ID = l_org_id
490: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
491:

Line 831: Update BOM_STRUCTURES_B

827: */
828: PROCEDURE Dereference_Header(p_bill_sequence_id NUMBER)
829: IS
830: BEGIN
831: Update BOM_STRUCTURES_B
832: Set source_bill_sequence_id = common_bill_Sequence_id,
833: common_bill_sequence_id = bill_sequence_id
834: Where bill_sequence_id = p_bill_sequence_id;
835: END;

Line 971: FROM BOM_STRUCTURES_B

967: IS
968: Cursor get_common_orgs(p_bill_seq_id NUMBER)
969: IS
970: SELECT distinct organization_id
971: FROM BOM_STRUCTURES_B
972: WHERE source_bill_sequence_id = p_bill_seq_id;
973:
974: l_comp_rev_id NUMBER;
975:

Line 1022: from BOM_STRUCTURES_B

1018:
1019: Cursor get_structure_type(p_bill_seq_id NUMBER)
1020: IS
1021: SELECT structure_type_id
1022: from BOM_STRUCTURES_B
1023: where bill_sequence_id = p_bill_seq_id;
1024: default_wip_params NUMBER;
1025:
1026: Cursor get_dest_components(p_src_comp_seq_id IN NUMBER, p_dest_bill_sequence_id IN NUMBER)

Line 1066: from BOM_STRUCTURES_B

1062: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', default_wip_params);
1063: --arudresh_debug('BOM:DEFAULT_WIP_VALUES'|| default_wip_params);
1064: SELECT assembly_item_id, organization_id, alternate_bom_designator, effectivity_control
1065: into l_assy_item_id, l_dest_org_id, l_alt_bom_desg, l_effectivity_ctrl
1066: from BOM_STRUCTURES_B
1067: where bill_sequence_id = p_dest_bill_sequence_id;
1068:
1069: IF l_effectivity_ctrl in (2,3,4)
1070: THEN

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

1290: , comp_rec.from_minor_revision_id
1291: , comp_rec.component_sequence_id
1292: , comp_rec.basis_type
1293: , 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))
1294: FROM BOM_COMPONENTS_B comp_rec, MTL_SYSTEM_ITEMS_B item, BOM_STRUCTURES_B bom
1295: WHERE comp_rec.bill_sequence_id = p_src_bill_sequence_id
1296: AND bom.bill_sequence_id = comp_rec.bill_sequence_id
1297: AND comp_rec.COMPONENT_ITEM_ID = item.inventory_item_id
1298: AND item.organization_id = l_dest_org_id

Line 1458: from BOM_STRUCTURES_B

1454: )
1455: IS
1456: Cursor get_related_bills(p_src_bill_sequence_id NUMBER) IS
1457: Select *
1458: from BOM_STRUCTURES_B
1459: where source_bill_sequence_id <> common_bill_sequence_id
1460: and source_bill_sequence_id = p_src_bill_sequence_id;
1461:
1462: Cursor get_src_comp_details(p_src_comp_seq_id NUMBER) IS

Line 1813: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1809: and organization_id = l_dest_org_id;
1810:
1811: SELECT concatenated_segments
1812: into l_dest_assy_item
1813: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1814: where item.inventory_item_id = bom.assembly_item_id
1815: and item.organization_id = bom.organization_id
1816: and bom.bill_sequence_id = src_comp_details.bill_sequence_id;
1817:

Line 1866: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

1862: and organization_id = l_dest_org_id;
1863:
1864: SELECT concatenated_segments
1865: into l_dest_assy_item
1866: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
1867: where item.inventory_item_id = bom.assembly_item_id
1868: and item.organization_id = bom.organization_id
1869: and bom.bill_sequence_id = src_comp_details.bill_sequence_id;
1870:

Line 2236: FROM BOM_STRUCTURES_B

2232: x_Return_Status := FND_API.G_RET_STS_ERROR;
2233:
2234: SELECT Organization_id
2235: INTO l_dest_org_id
2236: FROM BOM_STRUCTURES_B
2237: WHERE bill_sequence_id = dest_comp.bill_sequence_id;
2238:
2239: SELECT concatenated_segments
2240: into l_comp_name

Line 2247: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

2243: and organization_id = l_dest_org_id;
2244:
2245: SELECT concatenated_segments
2246: into l_dest_assy_item
2247: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
2248: where item.inventory_item_id = bom.assembly_item_id
2249: and item.organization_id = bom.organization_id
2250: and bom.bill_sequence_id = src_comp.bill_sequence_id;
2251:

Line 2300: FROM BOM_STRUCTURES_B

2296: x_Return_Status := FND_API.G_RET_STS_ERROR;
2297:
2298: SELECT Organization_id
2299: INTO l_dest_org_id
2300: FROM BOM_STRUCTURES_B
2301: WHERE bill_sequence_id = dest_comp.bill_sequence_id;
2302:
2303: SELECT concatenated_segments
2304: into l_comp_name

Line 2311: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom

2307: and organization_id = l_dest_org_id;
2308:
2309: SELECT concatenated_segments
2310: into l_dest_assy_item
2311: from mtl_system_items_kfv item, BOM_STRUCTURES_B bom
2312: where item.inventory_item_id = bom.assembly_item_id
2313: and item.organization_id = bom.organization_id
2314: and bom.bill_sequence_id = src_comp.bill_sequence_id;
2315:

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

3330: WHERE bco.component_sequence_id = bic.component_sequence_id
3331: AND bic.component_sequence_id = p_component_sequence_id
3332: AND EXISTS(
3333: SELECT operation_seq_num, bos.routing_sequence_id
3334: FROM bom_operational_routings bor, bom_operation_sequences bos, BOM_STRUCTURES_B bom
3335: WHERE bos.routing_sequence_id = bor.common_routing_sequence_id
3336: AND bos.operation_seq_num = bco.operation_seq_num
3337: AND bor.assembly_item_id = bom.assembly_item_id
3338: AND bor.organization_id = bom.ORGANIZATION_id

Line 3774: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

3770:
3771: /* Cursor check_src_routing_exists(p_src_bill_sequence_id NUMBER)
3772: IS
3773: Select 'Routing Exists'
3774: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3775: Where bom.assembly_item_id = bor.assembly_item_id
3776: And bom.organization_id = bor.organizatin_id
3777: And nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3778: And bom.bill_sequence_id = p_src_bill_sequence_id*/

Line 3830: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

3826: --Check if Routing exists for the source bom
3827: BEGIN
3828: Select 'Routing Exists'
3829: INTO l_rtg_exist
3830: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3831: Where bom.assembly_item_id = bor.assembly_item_id
3832: And bom.organization_id = bor.organization_id
3833: And (nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3834: OR bor.alternate_routing_designator IS NULL)

Line 3936: from BOM_STRUCTURES_B

3932:
3933: Cursor get_structure_type(p_bill_seq_id NUMBER)
3934: IS
3935: Select structure_type_id
3936: from BOM_STRUCTURES_B
3937: where bill_sequence_id = p_bill_seq_id;
3938:
3939: CURSOR C_DATA_LEVEL(p_data_level_name VARCHAR2) IS
3940: SELECT DATA_LEVEL_ID

Line 4044: FROM BOM_COMPONENTS_B bcb, BOM_STRUCTURES_B bsb

4040:
4041: Cursor get_dest_comps(p_src_comp_seq_id NUMBER, p_str_type_id NUMBER)
4042: IS
4043: SELECT bcb.component_sequence_id, bcb.bill_sequence_id
4044: FROM BOM_COMPONENTS_B bcb, BOM_STRUCTURES_B bsb
4045: WHERE bcb.common_component_sequence_id = p_src_comp_seq_id
4046: AND bcb.common_component_sequence_id <> bcb.component_sequence_id
4047: AND bsb.structure_type_id = p_str_type_id
4048: AND bsb.bill_sequence_id = bcb.bill_sequence_id

Line 4054: FROM BOM_STRUCTURES_B

4050:
4051: Cursor get_structure_type(p_bill_seq_id NUMBER)
4052: IS
4053: SELECT structure_type_id
4054: FROM BOM_STRUCTURES_B
4055: WHERE bill_sequence_id = p_bill_seq_id;
4056:
4057: Cursor Get_Attribute_Groups(p_component_seq_id NUMBER, p_bill_seq_id NUMBER)
4058: IS

Line 4177: from BOM_STRUCTURES_B

4173: IS
4174:
4175: Cursor get_related_bills(p_src_bill_sequence_id NUMBER) IS
4176: Select bill_sequence_id, organization_id, assembly_item_id, alternate_bom_designator
4177: from BOM_STRUCTURES_B
4178: where source_bill_sequence_id <> common_bill_sequence_id
4179: and source_bill_sequence_id = p_src_bill_sequence_id;
4180:
4181:

Line 4206: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

4202:
4203: BEGIN
4204: Select 'Routing Exists'
4205: INTO l_rtg_exist
4206: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
4207: Where bom.assembly_item_id = bor.assembly_item_id
4208: And bom.organization_id = bor.organization_id
4209: And (nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
4210: OR bor.alternate_routing_designator IS NULL

Line 4899: FROM bom_structures_b

4895: RETURN VARCHAR2
4896: IS
4897: CURSOR get_orgs IS
4898: SELECT DISTINCT organization_id
4899: FROM bom_structures_b
4900: WHERE source_bill_Sequence_id = p_src_bill_seq_id;
4901:
4902: BEGIN
4903: FOR org IN get_orgs