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

Line 57: --| 20/01/2006 myerrams Replaced the view BOM_BILL_OF_MATERIALS |

53: --| 12/12/2005 vmutyala Modified Get_Err_Routings to remove inconsistancy |
54: --| in comparing routings |
55: --| 19/12/2005 vmutyala Modified Get_Err_Bom_Bom to remove inconsistancy |
56: --| in comparing Bom |
57: --| 20/01/2006 myerrams Replaced the view BOM_BILL_OF_MATERIALS |
58: --| with BOM_STRUCTURES_B table. Bug: 4913484. |
59: --| 26/12/2006 myerrams Bug5592181 Added New function Get_Err_StdOperations|
60: --| to Validate StandardOperations created for new org |
61: --| against those in model org. |

Line 1738: FROM BOM_BILL_OF_MATERIALS bom

1734: , p_organization_id NUMBER
1735: )
1736: IS
1737: SELECT msi.CONCATENATED_SEGMENTS
1738: FROM BOM_BILL_OF_MATERIALS bom
1739: , MTL_SYSTEM_ITEMS_KFV msi
1740: WHERE msi.ORGANIZATION_ID = bom.ORGANIZATION_ID
1741: AND msi.INVENTORY_ITEM_ID = bom.ASSEMBLY_ITEM_ID
1742: AND bom.ORGANIZATION_ID = p_model_org_id

Line 1745: FROM BOM_BILL_OF_MATERIALS bom1

1741: AND msi.INVENTORY_ITEM_ID = bom.ASSEMBLY_ITEM_ID
1742: AND bom.ORGANIZATION_ID = p_model_org_id
1743: AND NOT EXISTS
1744: ( SELECT 'x'
1745: FROM BOM_BILL_OF_MATERIALS bom1
1746: WHERE bom1.ORGANIZATION_ID = p_organization_id
1747: AND bom1.ASSEMBLY_ITEM_ID = bom.ASSEMBLY_ITEM_ID
1748: /*vmutyala added this condition because alternate boms which are not copied are not being reported by earlier query*/
1749: AND nvl(bom.ALTERNATE_BOM_DESIGNATOR,'NULL') = nvl(bom1.ALTERNATE_BOM_DESIGNATOR,'NULL')

Line 1755: FROM BOM_STRUCTURES_B --myerrams, Bug: 4913484. Replaced the view BOM_BILL_OF_MATERIALS with BOM_STRUCTURES_B table

1751:
1752: CURSOR l_parent_cnt ( p_org_id NUMBER )
1753: IS
1754: SELECT COUNT(ASSEMBLY_ITEM_ID)
1755: FROM BOM_STRUCTURES_B --myerrams, Bug: 4913484. Replaced the view BOM_BILL_OF_MATERIALS with BOM_STRUCTURES_B table
1756: WHERE ORGANIZATION_ID = p_org_id;
1757:
1758: CURSOR l_child_1 ( p_model_org_id NUMBER
1759: , p_organization_id NUMBER

Line 1764: , BOM_BILL_OF_MATERIALS bom

1760: )
1761: IS
1762: SELECT kfv.CONCATENATED_SEGMENTS, COUNT(bic.COMPONENT_SEQUENCE_ID)
1763: FROM BOM_INVENTORY_COMPONENTS bic
1764: , BOM_BILL_OF_MATERIALS bom
1765: , MTL_SYSTEM_ITEMS_KFV kfv
1766: WHERE bom.ORGANIZATION_ID = p_model_org_id
1767: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
1768: AND kfv.INVENTORY_ITEM_ID = bom.ASSEMBLY_ITEM_ID

Line 1774: , BOM_BILL_OF_MATERIALS bom1

1770: AND NOT EXISTS
1771: (
1772: SELECT 'x'
1773: FROM BOM_INVENTORY_COMPONENTS bic1
1774: , BOM_BILL_OF_MATERIALS bom1
1775: WHERE bom1.ORGANIZATION_ID = p_organization_id
1776: AND bic1.BILL_SEQUENCE_ID = bom1.BILL_SEQUENCE_ID
1777: AND bom1.ASSEMBLY_ITEM_ID = bom.ASSEMBLY_ITEM_ID
1778: /*vmutyala added this condition because alternate boms which are not copied are not being reported by earlier query*/

Line 1788: , BOM_BILL_OF_MATERIALS bom

1784: CURSOR l_child_1_cnt (p_org_id NUMBER)
1785: IS
1786: SELECT COUNT(bic.COMPONENT_SEQUENCE_ID)
1787: FROM BOM_INVENTORY_COMPONENTS bic
1788: , BOM_BILL_OF_MATERIALS bom
1789: WHERE bom.ORGANIZATION_ID = p_org_id
1790: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID;
1791:
1792: CURSOR l_child_2 ( p_model_org_id NUMBER

Line 1799: , BOM_BILL_OF_MATERIALS bom

1795: IS
1796: SELECT msi.CONCATENATED_SEGMENTS, COUNT(bsc.COMPONENT_SEQUENCE_ID)
1797: FROM BOM_SUBSTITUTE_COMPONENTS bsc
1798: , BOM_INVENTORY_COMPONENTS bic
1799: , BOM_BILL_OF_MATERIALS bom
1800: , MTL_SYSTEM_ITEMS_KFV msi
1801: WHERE bom.ORGANIZATION_ID = p_model_org_id
1802: AND msi.ORGANIZATION_ID = bom.ORGANIZATION_ID
1803: AND msi.INVENTORY_ITEM_ID = bom.ASSEMBLY_ITEM_ID

Line 1810: , BOM_BILL_OF_MATERIALS bom1

1806: AND NOT EXISTS
1807: (
1808: SELECT 'x'
1809: FROM BOM_INVENTORY_COMPONENTS bic1
1810: , BOM_BILL_OF_MATERIALS bom1
1811: , BOM_SUBSTITUTE_COMPONENTS bsc1
1812: WHERE bom1.ORGANIZATION_ID = p_organization_id
1813: AND bic1.BILL_SEQUENCE_ID = bom1.BILL_SEQUENCE_ID
1814: AND bsc1.COMPONENT_SEQUENCE_ID = bic1.COMPONENT_SEQUENCE_ID

Line 1828: , BOM_BILL_OF_MATERIALS bom

1824: CURSOR l_child_2_cnt (p_org_id NUMBER)
1825: IS
1826: SELECT COUNT(bsc.SUBSTITUTE_COMPONENT_ID)
1827: FROM BOM_INVENTORY_COMPONENTS bic
1828: , BOM_BILL_OF_MATERIALS bom
1829: , BOM_SUBSTITUTE_COMPONENTS bsc
1830: WHERE bom.ORGANIZATION_ID = p_org_id
1831: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
1832: AND bsc.COMPONENT_SEQUENCE_ID = bic.COMPONENT_SEQUENCE_ID;

Line 1841: , BOM_BILL_OF_MATERIALS bom

1837: IS
1838: SELECT msi.CONCATENATED_SEGMENTS, COUNT(brd.COMPONENT_SEQUENCE_ID)
1839: FROM BOM_REFERENCE_DESIGNATORS brd
1840: , BOM_INVENTORY_COMPONENTS bic
1841: , BOM_BILL_OF_MATERIALS bom
1842: , MTL_SYSTEM_ITEMS_KFV msi
1843: WHERE bom.ORGANIZATION_ID = p_model_org_id
1844: AND msi.ORGANIZATION_ID = bom.ORGANIZATION_ID
1845: AND msi.INVENTORY_ITEM_ID = bom.ASSEMBLY_ITEM_ID

Line 1852: , BOM_BILL_OF_MATERIALS bom1

1848: AND NOT EXISTS
1849: (
1850: SELECT 'x'
1851: FROM BOM_INVENTORY_COMPONENTS bic1
1852: , BOM_BILL_OF_MATERIALS bom1
1853: , BOM_REFERENCE_DESIGNATORS brd1
1854: WHERE bom1.ORGANIZATION_ID = p_organization_id
1855: AND bic1.BILL_SEQUENCE_ID = bom1.BILL_SEQUENCE_ID
1856: AND brd1.COMPONENT_SEQUENCE_ID = bic1.COMPONENT_SEQUENCE_ID

Line 1870: , BOM_BILL_OF_MATERIALS bom

1866: CURSOR l_child_3_cnt (p_org_id NUMBER)
1867: IS
1868: SELECT COUNT(brd.COMPONENT_REFERENCE_DESIGNATOR)
1869: FROM BOM_INVENTORY_COMPONENTS bic
1870: , BOM_BILL_OF_MATERIALS bom
1871: , BOM_REFERENCE_DESIGNATORS brd
1872: WHERE bom.ORGANIZATION_ID = p_org_id
1873: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
1874: AND brd.COMPONENT_SEQUENCE_ID = bic.COMPONENT_SEQUENCE_ID;

Line 1883: , BOM_BILL_OF_MATERIALS bom

1879: IS
1880: SELECT msi.CONCATENATED_SEGMENTS, COUNT(bco.COMPONENT_SEQUENCE_ID)
1881: FROM BOM_COMPONENT_OPERATIONS bco
1882: , BOM_INVENTORY_COMPONENTS bic
1883: , BOM_BILL_OF_MATERIALS bom
1884: , MTL_SYSTEM_ITEMS_KFV msi
1885: WHERE bom.ORGANIZATION_ID = p_model_org_id
1886: AND msi.ORGANIZATION_ID = bom.ORGANIZATION_ID
1887: AND msi.INVENTORY_ITEM_ID = bom.ASSEMBLY_ITEM_ID

Line 1894: , BOM_BILL_OF_MATERIALS bom1

1890: AND NOT EXISTS
1891: (
1892: SELECT 'x'
1893: FROM BOM_INVENTORY_COMPONENTS bic1
1894: , BOM_BILL_OF_MATERIALS bom1
1895: , BOM_COMPONENT_OPERATIONS bco1
1896: WHERE bom1.ORGANIZATION_ID = p_organization_id
1897: AND bic1.BILL_SEQUENCE_ID = bom1.BILL_SEQUENCE_ID
1898: AND bco1.COMPONENT_SEQUENCE_ID = bic1.COMPONENT_SEQUENCE_ID

Line 1910: , BOM_BILL_OF_MATERIALS bom

1906: CURSOR l_child_4_cnt (p_org_id NUMBER)
1907: IS
1908: SELECT COUNT(bco.COMP_OPERATION_SEQ_ID)
1909: FROM BOM_INVENTORY_COMPONENTS bic
1910: , BOM_BILL_OF_MATERIALS bom
1911: , BOM_COMPONENT_OPERATIONS bco
1912: WHERE bom.ORGANIZATION_ID = p_org_id
1913: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
1914: AND bco.COMPONENT_SEQUENCE_ID = bic.COMPONENT_SEQUENCE_ID;