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_SUB_OPERATION_RESOURCES

Line 3195: FROM BOM_SUB_OPERATION_RESOURCES bsor

3191: IS
3192: SELECT msi.CONCATENATED_SEGMENTS
3193: , boru.ALTERNATE_ROUTING_DESIGNATOR
3194: , COUNT(bsor.SUBSTITUTE_GROUP_NUM)
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

Line 3209: FROM BOM_SUB_OPERATION_RESOURCES bsor1

3205: AND bsor.OPERATION_SEQUENCE_ID = bor.OPERATION_SEQUENCE_ID
3206: AND bsor.RESOURCE_ID = bor.RESOURCE_ID
3207: AND NOT EXISTS
3208: ( SELECT 'x'
3209: FROM BOM_SUB_OPERATION_RESOURCES bsor1
3210: , BOM_OPERATION_RESOURCES bor1
3211: , BOM_OPERATION_SEQUENCES bos1
3212: , BOM_OPERATIONAL_ROUTINGS boru1
3213: WHERE boru1.ORGANIZATION_ID = p_organization_id

Line 3234: FROM BOM_SUB_OPERATION_RESOURCES bsor

3230: IS
3231: SELECT msi.CONCATENATED_SEGMENTS
3232: , boru.ALTERNATE_ROUTING_DESIGNATOR
3233: , COUNT(bsor.SUBSTITUTE_GROUP_NUM)
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

Line 3248: FROM BOM_SUB_OPERATION_RESOURCES bsor1

3244: AND bsor.OPERATION_SEQUENCE_ID = bor.OPERATION_SEQUENCE_ID
3245: AND bsor.RESOURCE_ID = bor.RESOURCE_ID
3246: AND NOT EXISTS
3247: ( SELECT 'x'
3248: FROM BOM_SUB_OPERATION_RESOURCES bsor1
3249: , BOM_OPERATION_RESOURCES bor1
3250: , BOM_OPERATION_SEQUENCES bos1
3251: , BOM_OPERATIONAL_ROUTINGS boru1
3252: WHERE boru1.ORGANIZATION_ID = p_organization_id

Line 3278: , BOM_SUB_OPERATION_RESOURCES bsor

3274: SELECT COUNT(bsor.SUBSTITUTE_GROUP_NUM)
3275: FROM BOM_OPERATIONAL_ROUTINGS boru
3276: , BOM_OPERATION_SEQUENCES bos
3277: , BOM_OPERATION_RESOURCES bor
3278: , BOM_SUB_OPERATION_RESOURCES bsor
3279: WHERE bsor.RESOURCE_ID = bor.RESOURCE_ID
3280: AND bsor.OPERATION_SEQUENCE_ID = bor.OPERATION_SEQUENCE_ID
3281: AND bor.OPERATION_SEQUENCE_ID = bos.OPERATION_SEQUENCE_ID
3282: AND bos.ROUTING_SEQUENCE_ID = boru.ROUTING_SEQUENCE_ID