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.ENGPKIMP dependencies on BOM_BILL_OF_MATERIALS

Line 96: FROM bom_bill_of_materials bbom,

92: SELECT count(1)
93: FROM DUAL
94: WHERE EXISTS (
95: SELECT 1
96: FROM bom_bill_of_materials bbom,
97: bom_inventory_components bic,
98: mtl_system_items msi
99: WHERE bbom.assembly_item_id = L_NEW_ASSEMBLY_ITEM_ID
100: AND bbom.organization_id = VAR_ORGANIZATION_ID

Line 793: FROM bom_bill_of_materials

789: l_current_attr_group_id := rev_items.attribute_number_value;
790:
791: -- Check whether there are any structures created for the item with this change order ..
792: SELECT count(*) INTO l_pending_changes_count
793: FROM bom_bill_of_materials
794: WHERE assembly_item_id = l_inventory_item_id
795: AND organization_id = l_org_id
796: AND structure_type_id = l_current_attr_group_id
797: AND pending_from_ecn = ( SELECT change_notice FROM eng_engineering_changes

Line 809: FROM bom_components_b comp, bom_bill_of_materials bom

805: END IF;
806:
807: -- Check whether there are any component changes created for the item with this change order ..
808: SELECT count(*) INTO l_pending_changes_count
809: FROM bom_components_b comp, bom_bill_of_materials bom
810: WHERE revised_item_sequence_id = p_change_line_id
811: AND comp.implementation_date IS NULL
812: AND comp.bill_sequence_id = bom.bill_sequence_id
813: AND bom.structure_type_id = l_current_attr_group_id

Line 831: FROM bom_bill_of_materials bbom

827: WHERE op.revised_item_sequence_id = p_change_line_id
828: AND op.revised_item_sequence_id = ri.revised_item_sequence_id
829: AND op.implementation_date IS NULL
830: AND st.structure_type_id = ( SELECT bbom.structure_type_id
831: FROM bom_bill_of_materials bbom
832: WHERE bbom.bill_sequence_id = ri.bill_sequence_id )
833: AND st.structure_type_id = l_current_attr_group_id
834: AND op.change_notice = ( SELECT change_notice FROM eng_engineering_changes
835: WHERE change_id in (SELECT change_id FROM eng_revised_items

Line 1648: FROM bom_bill_of_materials

1644:
1645: CURSOR Get_Bill_of_Materials_Info( bill_id IN NUMBER) IS
1646: SELECT pending_from_ecn
1647: , alternate_bom_designator
1648: FROM bom_bill_of_materials
1649: WHERE bill_sequence_id = bill_id;
1650:
1651: CURSOR Get_Operational_Routing_Info( routing_id IN NUMBER) IS
1652: SELECT pending_from_ecn

Line 1844: from bom_bill_of_materials b

1840:
1841: Cursor get_common_bills is
1842: Select b.organization_id, b.assembly_item_id,
1843: b.bill_sequence_id
1844: from bom_bill_of_materials b
1845: where b.common_assembly_item_id = item.revised_item_id
1846: and b.common_organization_id = item.organization_id
1847: AND b.source_bill_sequence_id = item.bill_sequence_id; -- R12: Common BOM changes
1848: --and b.common_bill_sequence_id = item.bill_sequence_id;

Line 2649: bom_bill_of_materials b --3412747

2645: null bom_revision, -- Bug 3381547
2646: null routing_revision -- Bug 3381547
2647: FROM wip_discrete_jobs wdj,
2648: wip_entities we,
2649: bom_bill_of_materials b --3412747
2650: WHERE we.organization_id = wdj.organization_id
2651: AND we.wip_entity_id = wdj.wip_entity_id
2652: AND wdj.status_type = 1
2653: AND wdj.job_type = 1 -- 2986915

Line 2716: bom_bill_of_materials b --3412747

2712: null bom_revision, -- Bug 3381547
2713: null routing_revision -- Bug 3381547
2714: FROM wip_discrete_jobs wdj,
2715: wip_entities we,
2716: bom_bill_of_materials b --3412747
2717: WHERE we.organization_id = wdj.organization_id
2718: --WHERE we.organization_id = l_wip_organization_id
2719: AND wdj.wip_entity_id = we.wip_entity_id
2720: AND wdj.status_type = 1

Line 2752: bom_bill_of_materials b, --3412747

2748: wdj.bom_revision bom_revision, -- Bug 3381547
2749: wdj.routing_revision routing_revision -- Bug 3381547
2750: FROM wip_discrete_jobs wdj,
2751: wip_entities we,
2752: bom_bill_of_materials b, --3412747
2753: wip_requirement_operations o
2754: WHERE wdj.wip_entity_id = we.wip_entity_id
2755: AND wdj.status_type = 1
2756: AND wdj.job_type = 1 -- 2986915

Line 2775: from bom_bill_of_materials b2

2771: (wdj.alternate_bom_designator is not null
2772: and
2773: b.alternate_bom_designator is null
2774: and not exists (select null
2775: from bom_bill_of_materials b2
2776: where b2.organization_id = b.organization_id
2777: and b2.assembly_item_id = b.assembly_item_id
2778: and b2.alternate_bom_designator =
2779: wdj.alternate_bom_designator)

Line 2846: From bom_bill_of_materials bbom

2842: Cursor Check_Bill(p_item_id IN NUMBER,
2843: p_org_id IN NUMBER,
2844: p_alternate IN VARCHAR2) is
2845: Select 'x' dummy
2846: From bom_bill_of_materials bbom
2847: Where bbom.assembly_item_id = p_item_id
2848: And bbom.organization_id = p_org_id
2849: And nvl(bbom.alternate_bom_designator, 'PRIMARY ALTERNATE') =
2850: nvl(p_alternate, 'PRIMARY ALTERNATE')

Line 3180: select bill_sequence_id from bom_bill_of_materials where

3176: select 1 from mtl_system_items_b where inventory_item_id in
3177: (
3178: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3179: (
3180: select bill_sequence_id from bom_bill_of_materials where
3181: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3182: ORGANIZATION_ID = item.organization_id AND
3183: (
3184: (item.designator_selection_type = 1) --select everything

Line 3216: select bill_sequence_id from bom_bill_of_materials where

3212: select 1 from mtl_system_items_b where inventory_item_id in
3213: (
3214: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3215: (
3216: select bill_sequence_id from bom_bill_of_materials where
3217: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3218: ORGANIZATION_ID = item.organization_id AND
3219: (
3220: (item.designator_selection_type = 1) --select everything

Line 3274: select bill_sequence_id from bom_bill_of_materials where

3270: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3271: -- Get all the components for this item
3272: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3273: (
3274: select bill_sequence_id from bom_bill_of_materials where
3275: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3276: ORGANIZATION_ID = item.organization_id AND
3277: (
3278: (item.designator_selection_type = 1) --select everything

Line 3313: select bill_sequence_id from bom_bill_of_materials where

3309: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3310: -- Get all the components for this item
3311: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3312: (
3313: select bill_sequence_id from bom_bill_of_materials where
3314: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3315: ORGANIZATION_ID = item.organization_id AND
3316: (
3317: (item.designator_selection_type = 1) --select everything

Line 3384: select bill_sequence_id from bom_bill_of_materials where

3380: -- changes...
3381: SELECT Count(*) INTO l_no_components FROM dual WHERE EXISTS(
3382: select 1 from bom_components_b where bill_sequence_id in
3383: (
3384: select bill_sequence_id from bom_bill_of_materials where
3385: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3386: ORGANIZATION_ID = item.organization_id
3387: ) AND revised_item_sequence_id = revised_item AND acd_type <> acd_delete
3388: );

Line 3450: select bill_sequence_id from bom_bill_of_materials where

3446: select 1 from mtl_system_items_b where inventory_item_id in
3447: (
3448: select COMPONENT_ITEM_ID from bom_components_b WHERE bill_sequence_id IN
3449: (
3450: select bill_sequence_id from bom_bill_of_materials where
3451: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3452: ORGANIZATION_ID = item.organization_id
3453: )
3454: AND revised_item_sequence_id = revised_item AND acd_type <> acd_delete

Line 3484: select bill_sequence_id from bom_bill_of_materials where

3480: select SUBSTITUTE_COMPONENT_ID from bom_substitute_components where COMPONENT_SEQUENCE_ID in(
3481: -- Get all the components for this item
3482: select COMPONENT_SEQUENCE_ID from bom_components_b WHERE bill_sequence_id IN
3483: (
3484: select bill_sequence_id from bom_bill_of_materials where
3485: ASSEMBLY_ITEM_ID = item.revised_item_id AND
3486: ORGANIZATION_ID = item.organization_id
3487: ) AND revised_item_sequence_id = revised_item AND acd_type <> acd_delete
3488: ) AND acd_type <> acd_delete

Line 6130: from bom_bill_of_materials

6126: begin
6127:
6128: select assembly_type
6129: into l_bom_assembly_type
6130: from bom_bill_of_materials
6131: where bill_sequence_id = item.bill_sequence_id;
6132:
6133: end;
6134:

Line 7634: Update bom_bill_of_materials

7630: end loop; -- all components
7631:
7632:
7633:
7634: Update bom_bill_of_materials
7635: set last_update_date = sysdate,
7636: last_updated_by = userid,
7637: last_update_login = loginid,
7638: request_id = reqstid,

Line 7689: -- when a row in bom_bill_of_materials has been updated:

7685: IF (l_eres_enabled = 'Y')
7686: THEN
7687: -- bug 3234628, May-2004:
7688: -- odaboval added this test in order to only raise an ERES event
7689: -- when a row in bom_bill_of_materials has been updated:
7690: -- bug 3741444 : added bERES_Flag_for_BOM in the condition
7691: -- and removed ROWCOUNT>0 from the condition.
7692: IF (bERES_Flag_for_BOM)
7693: THEN

Line 9564: FROM BOM_BILL_OF_MATERIALS B ,ENG_REVISED_ITEMS R

9560: BEGIN
9561: FND_FILE.PUT_LINE( FND_FILE.LOG, '********* Update_BSB_Request_Id_Column procedure Start *********') ;
9562: IF FND_API.To_Boolean(p_autonomous_commit) THEN
9563: SELECT B.BILL_SEQUENCE_ID INTO l_bill_sequence_id
9564: FROM BOM_BILL_OF_MATERIALS B ,ENG_REVISED_ITEMS R
9565: WHERE R.REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id
9566: AND R.REVISED_ITEM_ID = B.ASSEMBLY_ITEM_ID
9567: AND R.ORGANIZATION_ID = B.ORGANIZATION_ID
9568: AND NVL(R.ALTERNATE_BOM_DESIGNATOR,' ') = NVL(B.ALTERNATE_BOM_DESIGNATOR,' ')

Line 9575: update BOM_BILL_OF_MATERIALS bbm

9571: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Revised Item Sequence Id: ' || p_revised_item_sequence_id);
9572: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Bill Sequence Id of the Revised Item: ' || l_bill_sequence_id);
9573: FND_FILE.PUT_LINE( FND_FILE.LOG, 'System Date: ' || sysdate);
9574:
9575: update BOM_BILL_OF_MATERIALS bbm
9576: set bbm.REQUEST_ID = P_ECOIMPL_IS_RUNNING
9577: WHERE nvl(bbm.REQUEST_ID, 0) <> P_COMMONBOM_IS_RUNNING
9578: AND bbm.BILL_SEQUENCE_ID = l_bill_sequence_id;
9579: if(SQL%ROWCOUNT = 0 )