APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on WIP_DISCRETE_JOBS

Line 139: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,

135: repair_number CSD_REPAIRS.repair_number%type,
136: promise_date CSD_REPAIRS.promise_date%type,
137: ro_serial_num CSD_REPAIRS.serial_number%type ,
138: ro_item_id CSD_REPAIRS.inventory_item_id%type ,
139: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,
140: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
141: date_completed WIP_DISCRETE_JOBS.date_completed%type,
142: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
143: wip_entity_name WIP_ENTITIES.wip_entity_name%type,

Line 140: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,

136: promise_date CSD_REPAIRS.promise_date%type,
137: ro_serial_num CSD_REPAIRS.serial_number%type ,
138: ro_item_id CSD_REPAIRS.inventory_item_id%type ,
139: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,
140: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
141: date_completed WIP_DISCRETE_JOBS.date_completed%type,
142: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
143: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
144: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type

Line 141: date_completed WIP_DISCRETE_JOBS.date_completed%type,

137: ro_serial_num CSD_REPAIRS.serial_number%type ,
138: ro_item_id CSD_REPAIRS.inventory_item_id%type ,
139: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,
140: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
141: date_completed WIP_DISCRETE_JOBS.date_completed%type,
142: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
143: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
144: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type
145:

Line 142: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,

138: ro_item_id CSD_REPAIRS.inventory_item_id%type ,
139: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,
140: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
141: date_completed WIP_DISCRETE_JOBS.date_completed%type,
142: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
143: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
144: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type
145:
146: );

Line 156: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,

152: organization_id CSD_REPAIR_JOB_XREF.organization_id%type,
153: allocated_job_qty CSD_REPAIR_JOB_XREF.quantity%type ,
154: wip_entity_id WIP_ENTITIES.wip_entity_id%type,
155: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
156: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
157: creation_date WIP_DISCRETE_JOBS.creation_date%type
158: );
159:
160: --------------------

Line 157: creation_date WIP_DISCRETE_JOBS.creation_date%type

153: allocated_job_qty CSD_REPAIR_JOB_XREF.quantity%type ,
154: wip_entity_id WIP_ENTITIES.wip_entity_id%type,
155: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
156: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
157: creation_date WIP_DISCRETE_JOBS.creation_date%type
158: );
159:
160: --------------------
161: PROCEDURE check_for_cancelled_order(p_repair_line_id NUMBER);

Line 745: WIP_DISCRETE_JOBS wdj,

741: we.wip_entity_name,
742: mtl.serial_number_control_code
743: from CSD_REPAIR_JOB_XREF crj,
744: CSD_REPAIRS cra,
745: WIP_DISCRETE_JOBS wdj,
746: WIP_ENTITIES we,
747: MTL_SYSTEM_ITEMS mtl
748: where wdj.wip_entity_id = crj.wip_entity_id
749: and we.wip_entity_id = wdj.wip_entity_id

Line 781: WIP_DISCRETE_JOBS wdj,

777: we.wip_entity_name,
778: mtl.serial_number_control_code
779: from CSD_REPAIR_JOB_XREF crj,
780: CSD_REPAIRS cra,
781: WIP_DISCRETE_JOBS wdj,
782: WIP_ENTITIES we,
783: MTL_SYSTEM_ITEMS mtl
784: where wdj.wip_entity_id = crj.wip_entity_id
785: and we.wip_entity_id = wdj.wip_entity_id

Line 920: -- In WIP_DISCRETE_JOBS

916:
917: IF l_remaining_qty > 0 then
918: IF JOB.serial_number_control_code in (2,5) THEN
919: -- Serialized at inventory receipt and Pre-defined
920: -- In WIP_DISCRETE_JOBS
921: -- Job Name Job Id Start Qty Completion Qty Completion Subinv
922: -- W1 1121 10 10
923: --
924: -- MTL_MATERIAL_TRANSACTIONS

Line 1030: -- Wip Discrete Jobs

1026: -- R1 A 1 W1 Sn1
1027: -- R2 A 1 W1 Sn2
1028: -- R3 A 1 W1 Sn3
1029: --
1030: -- Wip Discrete Jobs
1031: -- Job Start Qty Comp Qty
1032: -- W1 3 3
1033: --
1034: -- MTL Material Transactions

Line 1287: -- In WIP_DISCRETE_JOBS

1283: END IF;
1284:
1285: ELSE
1286: -- This scenario is for the serialized item at sales order issue and non-serialized
1287: -- In WIP_DISCRETE_JOBS
1288: -- Job Name Job Id Start Qty Completion Qty Completion Subinv
1289: -- W1 1121 10 10
1290: --
1291: -- MTL_MATERIAL_TRANSACTIONS

Line 1566: wip_discrete_jobs wdj

1562: wdj.start_quantity job_qty,
1563: wdj.creation_date
1564: from CSD_REPAIR_JOB_XREF crj,
1565: WIP_ENTITIES we,
1566: wip_discrete_jobs wdj
1567: where wdj.wip_entity_id = we.wip_entity_id
1568: and crj.job_name = we.wip_entity_name
1569: and crj.organization_id = we.organization_id
1570: and crj.repair_line_id = p_rep_line_id

Line 1586: wip_discrete_jobs wdj

1582: wdj.start_quantity job_qty,
1583: wdj.creation_date
1584: from CSD_REPAIR_JOB_XREF crj,
1585: WIP_ENTITIES we,
1586: wip_discrete_jobs wdj
1587: where wdj.wip_entity_id = we.wip_entity_id
1588: and crj.job_name = we.wip_entity_name
1589: and crj.organization_id = we.organization_id
1590: and crj.wip_entity_id is null;

Line 1622: -- with the job name. Once the WIP Job is created in wip_discrete_jobs

1618: -- for commiting purpose
1619: l_count := 0;
1620:
1621: -- When Jobs are created from the UI, a record is inserted in csd_repair_job_xref
1622: -- with the job name. Once the WIP Job is created in wip_discrete_jobs
1623: -- then the update program will find the wip_entity_id and update it.
1624: -- Also it updates the quantity_in_wip in the csd_repairs with Job start quantity
1625: --
1626: -- When the WIP Job is submitted from the UI, the record would look as follows: