DBA Data[Home] [Help]

APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on WIP_REQUIREMENT_OPERATIONS

Line 2117: WIP_REQUIREMENT_OPERATIONS WRO

2113: decode(WE.ENTITY_TYPE,5,5,8,5,1) JOB_TYPE,
2114: SUM(WRO.REQUIRED_QUANTITY) Standard_Quantity
2115: FROM
2116: WIP_ENTITIES WE,
2117: WIP_REQUIREMENT_OPERATIONS WRO
2118: WHERE
2119: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2120: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2121: WE.ENTITY_TYPE in (1,3,5,8) AND

Line 2137: WIP_REQUIREMENT_OPERATIONS WRO

2133: 2 JOB_TYPE,
2134: SUM(WRO.REQUIRED_QUANTITY) Standard_Quantity
2135: FROM
2136: WIP_ENTITIES WE,
2137: WIP_REQUIREMENT_OPERATIONS WRO
2138: WHERE
2139: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2140: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2141: WE.ENTITY_TYPE = 2 AND

Line 2344: WIP_REQUIREMENT_OPERATIONS WRO

2340: decode(WE.ENTITY_TYPE,5,5,8,5,1) JOB_TYPE,
2341: SUM(WRO.REQUIRED_QUANTITY) Standard_Quantity
2342: FROM
2343: WIP_ENTITIES WE,
2344: WIP_REQUIREMENT_OPERATIONS WRO
2345: WHERE
2346: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2347: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2348: WE.ENTITY_TYPE in (1,3,5,8) AND

Line 2364: WIP_REQUIREMENT_OPERATIONS WRO

2360: 2 JOB_TYPE,
2361: SUM(WRO.REQUIRED_QUANTITY) Standard_Quantity
2362: FROM
2363: WIP_ENTITIES WE,
2364: WIP_REQUIREMENT_OPERATIONS WRO
2365: WHERE
2366: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2367: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2368: WE.ENTITY_TYPE = 2 AND