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 5036: type t_job_wip_entity_id is table of wip_discrete_jobs.wip_entity_id %type;

5032: -- ==============================================================================================
5033: -- table types used to bulk bind data from job tables to the PL/SQL tables.
5034: -- ==============================================================================================
5035: type t_job_wip_entity_name is table of wip_entities.wip_entity_name %type;
5036: type t_job_wip_entity_id is table of wip_discrete_jobs.wip_entity_id %type;
5037: type t_job_organization_id is table of wip_discrete_jobs.organization_id %type;
5038: type t_job_status_type is table of wip_discrete_jobs.status_type %type;
5039: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;
5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;

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

5033: -- table types used to bulk bind data from job tables to the PL/SQL tables.
5034: -- ==============================================================================================
5035: type t_job_wip_entity_name is table of wip_entities.wip_entity_name %type;
5036: type t_job_wip_entity_id is table of wip_discrete_jobs.wip_entity_id %type;
5037: type t_job_organization_id is table of wip_discrete_jobs.organization_id %type;
5038: type t_job_status_type is table of wip_discrete_jobs.status_type %type;
5039: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;
5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;

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

5034: -- ==============================================================================================
5035: type t_job_wip_entity_name is table of wip_entities.wip_entity_name %type;
5036: type t_job_wip_entity_id is table of wip_discrete_jobs.wip_entity_id %type;
5037: type t_job_organization_id is table of wip_discrete_jobs.organization_id %type;
5038: type t_job_status_type is table of wip_discrete_jobs.status_type %type;
5039: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;
5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;

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

5035: type t_job_wip_entity_name is table of wip_entities.wip_entity_name %type;
5036: type t_job_wip_entity_id is table of wip_discrete_jobs.wip_entity_id %type;
5037: type t_job_organization_id is table of wip_discrete_jobs.organization_id %type;
5038: type t_job_status_type is table of wip_discrete_jobs.status_type %type;
5039: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;
5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
5043: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;

Line 5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;

5036: type t_job_wip_entity_id is table of wip_discrete_jobs.wip_entity_id %type;
5037: type t_job_organization_id is table of wip_discrete_jobs.organization_id %type;
5038: type t_job_status_type is table of wip_discrete_jobs.status_type %type;
5039: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;
5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
5043: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
5044: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;

Line 5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;

5037: type t_job_organization_id is table of wip_discrete_jobs.organization_id %type;
5038: type t_job_status_type is table of wip_discrete_jobs.status_type %type;
5039: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;
5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
5043: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
5044: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
5045: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;

Line 5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;

5038: type t_job_status_type is table of wip_discrete_jobs.status_type %type;
5039: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;
5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
5043: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
5044: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
5045: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
5046: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;

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

5039: type t_job_primary_item_id is table of wip_discrete_jobs.primary_item_id %type;
5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
5043: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
5044: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
5045: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
5046: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5047: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;

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

5040: type t_job_routing_item_id is table of wip_discrete_jobs.primary_item_id %type;
5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
5043: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
5044: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
5045: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
5046: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5047: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5048: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;

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

5041: type t_job_alt_rtg_desig is table of wip_discrete_jobs.alternate_routing_designator %type;
5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
5043: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
5044: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
5045: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
5046: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5047: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5048: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
5049: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;

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

5042: type t_job_common_rtg_seq_id is table of wip_discrete_jobs.common_routing_sequence_id %type;
5043: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
5044: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
5045: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
5046: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5047: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5048: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
5049: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;
5050: type t_job_upg_success is table of number index by binary_integer;

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

5043: type t_job_routing_revision_date is table of wip_discrete_jobs.routing_revision_date %type;
5044: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
5045: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
5046: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5047: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5048: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
5049: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;
5050: type t_job_upg_success is table of number index by binary_integer;
5051: type t_job_err_buf is table of varchar2(2000) index by binary_integer;

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

5044: type t_job_bill_item_id is table of wip_discrete_jobs.primary_item_id %type;
5045: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
5046: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5047: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5048: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
5049: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;
5050: type t_job_upg_success is table of number index by binary_integer;
5051: type t_job_err_buf is table of varchar2(2000) index by binary_integer;
5052:

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

5045: type t_job_alt_bom_desig is table of wip_discrete_jobs.alternate_bom_designator %type;
5046: type t_job_bill_sequence_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5047: type t_job_common_bom_seq_id is table of wip_discrete_jobs.common_bom_sequence_id %type;
5048: type t_job_bom_revision_date is table of wip_discrete_jobs.bom_revision_date %type;
5049: type t_job_wip_supply_type is table of wip_discrete_jobs.wip_supply_type %type;
5050: type t_job_upg_success is table of number index by binary_integer;
5051: type t_job_err_buf is table of varchar2(2000) index by binary_integer;
5052:
5053: -- ==============================================================================================

Line 5094: wip_discrete_jobs wdj

5090: 1 upg_success, -- Will indicate Upgrade Successful or failure in the PLSQL table t_upgrade_jobs
5091: '' err_buf -- Will contain the error message for failed jobs
5092: FROM wsm_parameters wp,
5093: wip_entities we,
5094: wip_discrete_jobs wdj
5095: WHERE we.organization_id = wp.organization_id
5096: AND we.entity_type = 5
5097: AND wdj.organization_id = we.organization_id
5098: AND wdj.wip_entity_id = we.wip_entity_id

Line 5115: wip_discrete_jobs wdj

5111: SELECT wdj.wip_entity_id,
5112: wdj.common_routing_sequence_id common_rtg_seq_id
5113: FROM wsm_parameters wp,
5114: wip_entities we,
5115: wip_discrete_jobs wdj
5116: WHERE wdj.organization_id = wp.organization_id
5117: AND we.organization_id = wp.organization_id
5118: AND wdj.organization_id = we.organization_id
5119: AND wdj.wip_entity_id = we.wip_entity_id

Line 5497: from wip_discrete_jobs

5493:
5494: l_stmt_num := 20;
5495: select start_quantity
5496: into l_txn_quantity
5497: from wip_discrete_jobs
5498: where WIP_ENTITY_ID = p_wip_entity_id;
5499:
5500: l_stmt_num := 30;
5501: INSERT INTO WIP_OPERATIONS

Line 5608: WIP_DISCRETE_JOBS WDJ

5604: nvl(RECOMMENDED, 'N'),
5605: WDJ.QUANTITY_SCRAPPED,
5606: WCO.operation_seq_num
5607: FROM WSM_COPY_OPERATIONS WCO,
5608: WIP_DISCRETE_JOBS WDJ
5609: WHERE WDJ.wip_entity_id = WCO.wip_entity_id
5610: AND WCO.network_start_end = 'S'
5611: AND WCO.wip_entity_id = p_wip_entity_id;
5612:

Line 5759: FROM WIP_DISCRETE_JOBS WDJ,

5755: MSI.segment19,
5756: MSI.segment20,
5757: WCRO.department_id,
5758: ROUND(WDJ.start_quantity*WCRO.quantity_per_assembly, WSMPCNST.NUMBER_OF_DECIMALS)
5759: FROM WIP_DISCRETE_JOBS WDJ,
5760: WSM_COPY_REQUIREMENT_OPS WCRO,
5761: MTL_SYSTEM_ITEMS MSI
5762: WHERE WCRO.WIP_ENTITY_ID = p_wip_entity_id
5763: AND WCRO.OPERATION_SEQ_NUM = l_curr_op_seq_num