DBA Data[Home] [Help]

APPS.FLM_SUPPLY_DEMAND dependencies on WIP_REQUIREMENT_OPERATIONS

Line 780: WIP_REQUIREMENT_OPERATIONS O,

776: MTL_PARAMETERS P,
777: MTL_ATP_RULES R,
778: MTL_SYSTEM_ITEMS I,
779: BOM_CALENDAR_DATES C,
780: WIP_REQUIREMENT_OPERATIONS O,
781: WIP_DISCRETE_JOBS D
782: WHERE O.ORGANIZATION_ID=D.ORGANIZATION_ID
783: AND O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
784: AND O.WIP_ENTITY_ID=D.WIP_ENTITY_ID

Line 1059: WIP_REQUIREMENT_OPERATIONS O,

1055: MTL_PARAMETERS P,
1056: MTL_ATP_RULES R,
1057: MTL_SYSTEM_ITEMS I,
1058: BOM_CALENDAR_DATES C,
1059: WIP_REQUIREMENT_OPERATIONS O,
1060: WIP_DISCRETE_JOBS D,
1061: BOM_CALENDAR_DATES C1
1062: WHERE O.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
1063: AND O.ORGANIZATION_ID = V.ORGANIZATION_ID

Line 1161: WIP_REQUIREMENT_OPERATIONS WRO

1157: BOM_CALENDAR_DATES C,
1158: BOM_CALENDAR_DATES C1,
1159: WIP_REPETITIVE_SCHEDULES WRS,
1160: WIP_OPERATIONS WO,
1161: WIP_REQUIREMENT_OPERATIONS WRO
1162: WHERE WRO.ORGANIZATION_ID = V.ORGANIZATION_ID
1163: AND WRO.INVENTORY_ITEM_ID=V.INVENTORY_ITEM_ID
1164: AND V.AVAILABLE_TO_ATP = 1
1165: AND V.ATP_RULE_ID = R.RULE_ID