APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on WIP_DISCRETE_JOBS

Line 817: l_wip_job_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE;

813:
814: l_api_name CONSTANT VARCHAR2(30) := 'Get_Available_Replenishment_So';
815: l_api_version CONSTANT NUMBER := 1.0;
816:
817: l_wip_job_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE;
818: l_wip_job_complete_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE;
819: l_ship_lead_time MTL_INTERORG_SHIP_METHODS.intransit_time%TYPE;
820:
821: l_remaining_qty NUMBER;

Line 818: l_wip_job_complete_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE;

814: l_api_name CONSTANT VARCHAR2(30) := 'Get_Available_Replenishment_So';
815: l_api_version CONSTANT NUMBER := 1.0;
816:
817: l_wip_job_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE;
818: l_wip_job_complete_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE;
819: l_ship_lead_time MTL_INTERORG_SHIP_METHODS.intransit_time%TYPE;
820:
821: l_remaining_qty NUMBER;
822: l_tbl_index NUMBER;

Line 893: FROM WIP_DISCRETE_JOBS wdj,

889: -- Cursor to get the WIP Scheduled Start Date and End Date
890: CURSOR c_wip_date_cur IS
891: SELECT wdj.scheduled_start_date,
892: wdj.scheduled_completion_date
893: FROM WIP_DISCRETE_JOBS wdj,
894: JMF_SUBCONTRACT_ORDERS jso
895: WHERE wdj.wip_entity_id = jso.wip_entity_id
896: AND wdj.organization_id = jso.tp_organization_id
897: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id;