eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_JOBCOPIES_PVT dependencies on WIP_DISCRETE_JOBS

Line 4805: type t_job_wip_entity_id is table of wip_discrete_jobs.wip_entity_id %type;

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;
4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;

Line 4806: type t_job_organization_id is table of wip_discrete_jobs.organization_id %type;

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;
4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;

Line 4807: type t_job_status_type is table of wip_discrete_jobs.status_type %type;

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;
4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;

Line 4808: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;

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;
4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;

Line 4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %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;
4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;

Line 4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %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;
4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;

Line 4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_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;
4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
4815: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;

Line 4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;

4808: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;
4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
4815: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4816: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;

Line 4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;

4809: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
4815: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4816: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4817: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;

Line 4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;

4810: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
4815: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4816: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4817: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
4818: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;

Line 4815: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;

4811: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
4815: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4816: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4817: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
4818: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;
4819: type t_job_upg_success is table of number index by binary_integer;

Line 4816: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;

4812: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
4815: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4816: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4817: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
4818: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;
4819: type t_job_upg_success is table of number index by binary_integer;
4820: type t_job_err_buf is table of varchar2(2000) index by binary_integer;

Line 4817: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;

4813: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
4815: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4816: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4817: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
4818: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;
4819: type t_job_upg_success is table of number index by binary_integer;
4820: type t_job_err_buf is table of varchar2(2000) index by binary_integer;
4821:

Line 4818: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;

4814: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
4815: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4816: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
4817: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
4818: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;
4819: type t_job_upg_success is table of number index by binary_integer;
4820: type t_job_err_buf is table of varchar2(2000) index by binary_integer;
4821:
4822: -- ==============================================================================================

Line 4863: wip_discrete_jobs wdj

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
4867: AND wdj.wip_entity_id = we.wip_entity_id

Line 4884: wip_discrete_jobs wdj

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
4888: AND wdj.wip_entity_id = we.wip_entity_id

Line 5266: from wip_discrete_jobs

5262:
5263: l_stmt_num := 20;
5264: select start_quantity
5265: into l_txn_quantity
5266: from wip_discrete_jobs
5267: where WIP_ENTITY_ID = p_wip_entity_id;
5268:
5269: l_stmt_num := 30;
5270: INSERT INTO WIP_OPERATIONS

Line 5377: WIP_DISCRETE_JOBS WDJ

5373: nvl(RECOMMENDED, 'N'),
5374: WDJ.QUANTITY_SCRAPPED,
5375: WCO.operation_seq_num
5376: FROM WSM_COPY_OPERATIONS WCO,
5377: WIP_DISCRETE_JOBS WDJ
5378: WHERE WDJ.wip_entity_id = WCO.wip_entity_id
5379: AND WCO.network_start_end = 'S'
5380: AND WCO.wip_entity_id = p_wip_entity_id;
5381:

Line 5528: FROM WIP_DISCRETE_JOBS WDJ,

5524: MSI.segment19,
5525: MSI.segment20,
5526: WCRO.department_id,
5527: ROUND(WDJ.start_quantity*WCRO.quantity_per_assembly, WSMPCNST.NUMBER_OF_DECIMALS)
5528: FROM WIP_DISCRETE_JOBS WDJ,
5529: WSM_COPY_REQUIREMENT_OPS WCRO,
5530: MTL_SYSTEM_ITEMS MSI
5531: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id
5532: AND WCRO.OPERATION_SEQ_NUM = l_curr_op_seq_num