DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on WIP_ENTITIES

Line 4804: type t_job_wip_entity_name is table of wip_entities.wip_entity_name %type;

4800:
4801: -- ==============================================================================================
4802: -- table types used to bulk bind data from job tables to the PL/SQL tables.
4803: -- ==============================================================================================
4804: type t_job_wip_entity_name is table of wip_entities.wip_entity_name %type;
4805: type t_job_wip_entity_id is table of wip_discrete_jobs.wip_entity_id %type;
4806: type t_job_organization_id is table of wip_discrete_jobs.organization_id %type;
4807: type t_job_status_type is table of wip_discrete_jobs.status_type %type;
4808: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;

Line 4862: wip_entities we,

4858: wdj.wip_supply_type,
4859: 1 upg_success, -- Will indicate Upgrade Successful or failure in the PLSQL table t_upgrade_jobs
4860: '' err_buf -- Will contain the error message for failed jobs
4861: FROM wsm_parameters wp,
4862: wip_entities we,
4863: wip_discrete_jobs wdj
4864: WHERE we.organization_id = wp.organization_id
4865: AND we.entity_type = 5
4866: AND wdj.organization_id = we.organization_id

Line 4883: wip_entities we,

4879: CURSOR lot_based_jobs IS
4880: SELECT wdj.wip_entity_id,
4881: wdj.common_routing_sequence_id common_rtg_seq_id
4882: FROM wsm_parameters wp,
4883: wip_entities we,
4884: wip_discrete_jobs wdj
4885: WHERE wdj.organization_id = wp.organization_id
4886: AND we.organization_id = wp.organization_id
4887: AND wdj.organization_id = we.organization_id