DBA Data[Home] [Help]

APPS.BOM_GLOBALS dependencies on BOM_BILL_OF_MATERIALS

Line 1723: bom_bill_of_materials bom

1719: SELECT
1720: revision_id
1721: FROM
1722: mtl_item_revisions_B mir,
1723: bom_bill_of_materials bom
1724: WHERE
1725: mir.inventory_item_id = bom.assembly_item_id
1726: AND mir.organization_id = bom.organization_id
1727: AND bom.bill_sequence_id = p_bill_sequence_id

Line 1747: bom_bill_of_materials bom

1743: SELECT
1744: revision_id
1745: FROM
1746: mtl_item_revisions_B mir,
1747: bom_bill_of_materials bom
1748: WHERE
1749: mir.inventory_item_id = p_component_item_id
1750: AND mir.organization_id = bom.organization_id
1751: AND bom.bill_sequence_id = p_bill_sequence_id

Line 1783: ' bom_bill_of_materials bom '||

1779: stmt2 := ' SELECT '||
1780: ' nvl(max(minor_revision_id),0) minor_revision_id '||
1781: ' FROM '||
1782: ' ego_minor_revisions emr, '||
1783: ' bom_bill_of_materials bom '||
1784: ' WHERE '||
1785: ' emr.pk1_value = to_char(bom.assembly_item_id) '||
1786: ' AND emr.pk2_value = to_char(bom.organization_id)' ||
1787: ' AND bom.bill_sequence_id = :bill_seq_id' ||

Line 1808: ' bom_bill_of_materials bom '||

1804: stmt1 := ' SELECT '||
1805: 'nvl(max(minor_revision_id),0) minor_revision_id ' ||
1806: ' FROM '||
1807: ' ego_minor_revisions emr, '||
1808: ' bom_bill_of_materials bom '||
1809: ' WHERE '||
1810: ' emr.pk1_value = to_char(:comp_item_id) ' ||
1811: ' AND emr.pk2_value = to_char(bom.organization_id) '||
1812: ' AND bom.bill_sequence_id = :bill_seq_id ' ||