APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on MTL_INTERORG_SHIP_METHODS

Line 819: l_ship_lead_time MTL_INTERORG_SHIP_METHODS.intransit_time%TYPE;

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;
823: l_out_tbl_index NUMBER;

Line 835: l_oem_organization_id mtl_interorg_ship_methods.from_organization_id%TYPE;

831:
832: g_no_wip_job_found_exc EXCEPTION;
833: g_no_ship_method_found_exc EXCEPTION;
834:
835: l_oem_organization_id mtl_interorg_ship_methods.from_organization_id%TYPE;
836: l_tp_organization_id mtl_interorg_ship_methods.to_organization_id%TYPE;
837: l_message VARCHAR(2000);
838: l_status_flag BOOLEAN;
839: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

Line 836: l_tp_organization_id mtl_interorg_ship_methods.to_organization_id%TYPE;

832: g_no_wip_job_found_exc EXCEPTION;
833: g_no_ship_method_found_exc EXCEPTION;
834:
835: l_oem_organization_id mtl_interorg_ship_methods.from_organization_id%TYPE;
836: l_tp_organization_id mtl_interorg_ship_methods.to_organization_id%TYPE;
837: l_message VARCHAR(2000);
838: l_status_flag BOOLEAN;
839: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
840: l_oem_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

Line 905: FROM MTL_INTERORG_SHIP_METHODS mism,

901: CURSOR c_ship_lead_time_cur IS
902: SELECT NVL(mism.intransit_time, 0)
903: , FROM_organization_id
904: , to_organization_id
905: FROM MTL_INTERORG_SHIP_METHODS mism,
906: JMF_SUBCONTRACT_ORDERS jso
907: WHERE mism.from_organization_id = jso.oem_organization_id
908: AND mism.to_organization_id = jso.tp_organization_id
909: AND mism.default_flag = 1