APPS.FLM_SUPPLY_DEMAND dependencies on WIP_FLOW_SCHEDULES

Line 967: WIP_FLOW_SCHEDULES D,

963: TO_NUMBER(TO_CHAR(C.NEXT_DATE,'J')) supply_demand_date,
964: V.INVENTORY_ITEM_ID inventory_item_id,
965: V.ORGANIZATION_ID organization_id
966: FROM
967: WIP_FLOW_SCHEDULES D,
968: BOM_CALENDAR_DATES C,
969: MTL_PARAMETERS P,
970: MTL_SYSTEM_ITEMS I,
971: MTL_ATP_RULES R,

Line 1337: FROM WIP_FLOW_SCHEDULES F,

1333: V.ORGANIZATION_ID organization_id,
1334: F.primary_item_id assembly_item_id,
1335: F.bom_revision_date bom_revision_date,
1336: F.alternate_bom_designator alternate_bom_designator
1337: FROM WIP_FLOW_SCHEDULES F,
1338: BOM_BILL_OF_MATERIALS BOM ,
1339: BOM_EXPLOSIONS BE ,
1340: BOM_CALENDAR_DATES C,
1341: MTL_PARAMETERS P,

Line 1950: from wip_flow_schedules

1946: IF (l_temp_tbl(i).supply_demand_source_type = 24 AND l_temp_tbl(i).supply_demand_type = 1
1947: AND l_temp_tbl(i).supply_demand_date >= l_from_date_j) THEN
1948: select line_id
1949: into l_line_id
1950: from wip_flow_schedules
1951: where wip_entity_id = l_temp_tbl(i).supply_demand_source_id;
1952:
1953: FOR j in 1..p_ignore_line_id_tbl.count LOOP
1954: IF l_line_id = p_ignore_line_id_tbl(j) THEN