APPS.RLM_FORECAST_SV dependencies on MRP_FORECAST_DESIGNATORS

Line 298: v_forecast_designator mrp_forecast_designators.forecast_designator%TYPE;

294: mrp_forecast_interface_pk.t_forecast_designator,
295: x_ReturnStatus OUT NOCOPY NUMBER)
296: IS
297: --
298: v_forecast_designator mrp_forecast_designators.forecast_designator%TYPE;
299: x_progress VARCHAR2(3) := '010';
300: v_InterfaceLineId NUMBER;
301: --
302: BEGIN

Line 895: mrp_forecast_designators.forecast_designator%TYPE)

891: x_Sched_rec IN RLM_INTERFACE_HEADERS%ROWTYPE,
892: x_Group_rec IN rlm_dp_sv.t_Group_rec,
893: t_forecast IN OUT NOCOPY mrp_forecast_interface_pk.t_forecast_interface,
894: x_forecast_designator IN
895: mrp_forecast_designators.forecast_designator%TYPE)
896: IS
897:
898:
899: --

Line 1544: FROM mrp_forecast_designators

1540: END IF;
1541: --
1542: SELECT forecast_designator
1543: INTO x_ForecastDesignator
1544: FROM mrp_forecast_designators
1545: WHERE customer_id=NVL(x_ship_to_customer_id, x_customer_id)
1546: AND (bill_id = v_bill_site_id
1547: OR (bill_id IS NULL AND v_bill_site_id IS NULL))
1548: AND (ship_id = x_Ship_Site_Id

Line 1574: FROM mrp_forecast_designators

1570: /* To make match only at ShipTo level,additional check for NULL bill_id */
1571: --
1572: SELECT forecast_designator
1573: INTO x_ForecastDesignator
1574: FROM mrp_forecast_designators
1575: WHERE customer_id= nvl(x_ship_to_customer_id, x_customer_id)
1576: AND ship_id = x_Ship_Site_Id
1577: AND bill_id IS NULL
1578: AND organization_id = x_ShipFromOrgId

Line 1605: FROM mrp_forecast_designators

1601: BEGIN
1602: --
1603: SELECT forecast_designator
1604: INTO x_ForecastDesignator
1605: FROM mrp_forecast_designators
1606: WHERE customer_id= nvl(x_ship_to_customer_id, x_customer_id)
1607: AND ship_id IS NULL
1608: AND bill_id IS NULL
1609: AND organization_id = x_ShipFromOrgId

Line 1647: FROM mrp_forecast_designators

1643: BEGIN
1644: --{
1645: SELECT forecast_designator
1646: INTO x_ForecastDesignator
1647: FROM mrp_forecast_designators
1648: WHERE customer_id= x_customer_id
1649: AND ship_id IS NULL
1650: AND bill_id IS NULL
1651: AND organization_id = x_ShipFromOrgId