[Home] [Help]
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
1743: AND NOT EXISTS
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
1769: AND kfv.ORGANIZATION_ID = bom.ORGANIZATION_ID
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
1804: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
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
1846: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
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
1888: AND bic.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID
2241: )
2242: IS
2243: SELECT kfv.CONCATENATED_SEGMENTS
2244: FROM MTL_SYSTEM_ITEMS_B msi1
2245: , MTL_SYSTEM_ITEMS_KFV kfv
2246: WHERE kfv.ORGANIZATION_ID = msi1.ORGANIZATION_ID
2247: AND kfv.INVENTORY_ITEM_ID = msi1.INVENTORY_ITEM_ID
2248: AND msi1.ORGANIZATION_ID = p_model_org_id
2249: AND NOT EXISTS
2426: )
2427: IS
2428: SELECT kfv.CONCATENATED_SEGMENTS||': '||rev1.REVISION
2429: FROM MTL_ITEM_REVISIONS rev1
2430: , MTL_SYSTEM_ITEMS_KFV kfv
2431: WHERE kfv.ORGANIZATION_ID = rev1.ORGANIZATION_ID
2432: AND kfv.INVENTORY_ITEM_ID = rev1.INVENTORY_ITEM_ID
2433: AND rev1.ORGANIZATION_ID = p_model_org_id
2434: AND NOT EXISTS
2522: )
2523: IS
2524: SELECT kfv.CONCATENATED_SEGMENTS||': '||sub1.SECONDARY_INVENTORY
2525: FROM MTL_ITEM_SUB_INVENTORIES sub1
2526: , MTL_SYSTEM_ITEMS_KFV kfv
2527: WHERE kfv.ORGANIZATION_ID = sub1.ORGANIZATION_ID
2528: AND kfv.INVENTORY_ITEM_ID = sub1.INVENTORY_ITEM_ID
2529: AND sub1.ORGANIZATION_ID = p_model_org_id
2530: AND NOT EXISTS
3021: )
3022: IS
3023: SELECT DISTINCT msi.CONCATENATED_SEGMENTS, boru.ALTERNATE_ROUTING_DESIGNATOR
3024: FROM BOM_OPERATIONAL_ROUTINGS boru
3025: , MTL_SYSTEM_ITEMS_KFV msi
3026: WHERE msi.ORGANIZATION_ID = boru.ORGANIZATION_ID
3027: AND msi.INVENTORY_ITEM_ID = boru.ASSEMBLY_ITEM_ID
3028: AND boru.ORGANIZATION_ID = p_model_org_id
3029: AND NOT EXISTS
3050: , BOR.ALTERNATE_ROUTING_DESIGNATOR
3051: , COUNT(OPERATION_SEQ_NUM)
3052: FROM BOM_OPERATION_SEQUENCES BOS
3053: , BOM_OPERATIONAL_ROUTINGS BOR
3054: , MTL_SYSTEM_ITEMS_KFV MSI
3055: WHERE MSI.INVENTORY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID
3056: AND MSI.ORGANIZATION_ID = BOR.ORGANIZATION_ID
3057: AND BOS.ROUTING_SEQUENCE_ID = BOR.ROUTING_SEQUENCE_ID
3058: AND BOR.ORGANIZATION_ID = p_model_org_id
3076: , BOR.ALTERNATE_ROUTING_DESIGNATOR
3077: , COUNT(OPERATION_SEQ_NUM)
3078: FROM BOM_OPERATION_SEQUENCES BOS
3079: , BOM_OPERATIONAL_ROUTINGS BOR
3080: , MTL_SYSTEM_ITEMS_KFV MSI
3081: WHERE MSI.INVENTORY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID
3082: AND MSI.ORGANIZATION_ID = BOR.ORGANIZATION_ID
3083: AND BOS.ROUTING_SEQUENCE_ID = BOR.ROUTING_SEQUENCE_ID
3084: AND BOR.ORGANIZATION_ID = p_model_org_id
3117: , COUNT(bor.RESOURCE_ID)
3118: FROM BOM_OPERATION_RESOURCES bor
3119: , BOM_OPERATION_SEQUENCES bos
3120: , BOM_OPERATIONAL_ROUTINGS boru
3121: , MTL_SYSTEM_ITEMS_KFV msi
3122: WHERE boru.ORGANIZATION_ID = p_model_org_id
3123: AND msi.ORGANIZATION_ID = boru.ORGANIZATION_ID
3124: AND msi.INVENTORY_ITEM_ID = boru.ASSEMBLY_ITEM_ID
3125: AND bos.ROUTING_SEQUENCE_ID = boru.ROUTING_SEQUENCE_ID
3148: , COUNT(bor.RESOURCE_ID)
3149: FROM BOM_OPERATION_RESOURCES bor
3150: , BOM_OPERATION_SEQUENCES bos
3151: , BOM_OPERATIONAL_ROUTINGS boru
3152: , MTL_SYSTEM_ITEMS_KFV msi
3153: WHERE boru.ORGANIZATION_ID = p_model_org_id
3154: AND msi.ORGANIZATION_ID = boru.ORGANIZATION_ID
3155: AND msi.INVENTORY_ITEM_ID = boru.ASSEMBLY_ITEM_ID
3156: AND bos.ROUTING_SEQUENCE_ID = boru.ROUTING_SEQUENCE_ID
3195: FROM BOM_SUB_OPERATION_RESOURCES bsor
3196: , BOM_OPERATION_RESOURCES bor
3197: , BOM_OPERATION_SEQUENCES bos
3198: , BOM_OPERATIONAL_ROUTINGS boru
3199: , MTL_SYSTEM_ITEMS_KFV msi
3200: WHERE boru.ORGANIZATION_ID = p_model_org_id
3201: AND msi.ORGANIZATION_ID = boru.ORGANIZATION_ID
3202: AND msi.INVENTORY_ITEM_ID = boru.ASSEMBLY_ITEM_ID
3203: AND bos.ROUTING_SEQUENCE_ID = boru.ROUTING_SEQUENCE_ID
3234: FROM BOM_SUB_OPERATION_RESOURCES bsor
3235: , BOM_OPERATION_RESOURCES bor
3236: , BOM_OPERATION_SEQUENCES bos
3237: , BOM_OPERATIONAL_ROUTINGS boru
3238: , MTL_SYSTEM_ITEMS_KFV msi
3239: WHERE boru.ORGANIZATION_ID = p_model_org_id
3240: AND msi.ORGANIZATION_ID = boru.ORGANIZATION_ID
3241: AND msi.INVENTORY_ITEM_ID = boru.ASSEMBLY_ITEM_ID
3242: AND bos.ROUTING_SEQUENCE_ID = boru.ROUTING_SEQUENCE_ID
3287: )
3288: IS
3289: SELECT kfv.CONCATENATED_SEGMENTS
3290: FROM MTL_RTG_ITEM_REVISIONS rev
3291: , MTL_SYSTEM_ITEMS_KFV kfv
3292: WHERE kfv.ORGANIZATION_ID = rev.ORGANIZATION_ID
3293: AND kfv.INVENTORY_ITEM_ID = rev.INVENTORY_ITEM_ID
3294: AND rev.ORGANIZATION_ID = p_model_org_id
3295: AND NOT EXISTS