DBA Data[Home] [Help]

APPS.FLM_SUPPLY_DEMAND dependencies on WIP_DISCRETE_JOBS

Line 687: FROM WIP_DISCRETE_JOBS D,

683: D.START_QUANTITY - D.QUANTITY_COMPLETED - D.QUANTITY_SCRAPPED) supply_demand_quantity,
684: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
685: V.INVENTORY_ITEM_ID inventory_item_id,
686: V.ORGANIZATION_ID organization_id
687: FROM WIP_DISCRETE_JOBS D,
688: BOM_CALENDAR_DATES C,
689: MTL_PARAMETERS P,
690: MTL_SYSTEM_ITEMS I,
691: MTL_ATP_RULES R,

Line 781: WIP_DISCRETE_JOBS D

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
785: AND O.ORGANIZATION_ID = V.ORGANIZATION_ID

Line 1060: WIP_DISCRETE_JOBS D,

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
1064: AND O.WIP_SUPPLY_TYPE <> 6