DBA Data[Home] [Help]

APPS.WPS_SUPPLY_DEMAND dependencies on WIP_REQUIREMENT_OPERATIONS

Line 786: WIP_REQUIREMENT_OPERATIONS O,

782: MTL_PARAMETERS P,
783: MTL_ATP_RULES R,
784: MTL_SYSTEM_ITEMS I,
785: BOM_CALENDAR_DATES C,
786: WIP_REQUIREMENT_OPERATIONS O,
787: WIP_DISCRETE_JOBS D
788: WHERE O.ORGANIZATION_ID=D.ORGANIZATION_ID
789: AND O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
790: AND O.WIP_ENTITY_ID=D.WIP_ENTITY_ID

Line 1065: WIP_REQUIREMENT_OPERATIONS O,

1061: MTL_PARAMETERS P,
1062: MTL_ATP_RULES R,
1063: MTL_SYSTEM_ITEMS I,
1064: BOM_CALENDAR_DATES C,
1065: WIP_REQUIREMENT_OPERATIONS O,
1066: WIP_DISCRETE_JOBS D,
1067: BOM_CALENDAR_DATES C1
1068: WHERE O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
1069: AND O.ORGANIZATION_ID = V.ORGANIZATION_ID

Line 1167: WIP_REQUIREMENT_OPERATIONS WRO

1163: BOM_CALENDAR_DATES C,
1164: BOM_CALENDAR_DATES C1,
1165: WIP_REPETITIVE_SCHEDULES WRS,
1166: WIP_OPERATIONS WO,
1167: WIP_REQUIREMENT_OPERATIONS WRO
1168: WHERE WRO.ORGANIZATION_ID = V.ORGANIZATION_ID
1169: AND WRO.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
1170: AND V.AVAILABLE_TO_ATP = 1
1171: AND V.ATP_RULE_ID = R.RULE_ID