APPS.CSD_UPDATE_PROGRAMS_PVT dependencies on WIP_DISCRETE_JOBS

Line 146: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,

142: repair_number CSD_REPAIRS.repair_number%type,
143: promise_date CSD_REPAIRS.promise_date%type,
144: ro_serial_num CSD_REPAIRS.serial_number%type ,
145: ro_item_id CSD_REPAIRS.inventory_item_id%type ,
146: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,
147: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
148: date_completed WIP_DISCRETE_JOBS.date_completed%type,
149: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
150: wip_entity_name WIP_ENTITIES.wip_entity_name%type,

Line 147: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,

143: promise_date CSD_REPAIRS.promise_date%type,
144: ro_serial_num CSD_REPAIRS.serial_number%type ,
145: ro_item_id CSD_REPAIRS.inventory_item_id%type ,
146: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,
147: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
148: date_completed WIP_DISCRETE_JOBS.date_completed%type,
149: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
150: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
151: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type

Line 148: date_completed WIP_DISCRETE_JOBS.date_completed%type,

144: ro_serial_num CSD_REPAIRS.serial_number%type ,
145: ro_item_id CSD_REPAIRS.inventory_item_id%type ,
146: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,
147: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
148: date_completed WIP_DISCRETE_JOBS.date_completed%type,
149: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
150: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
151: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type
152:

Line 149: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,

145: ro_item_id CSD_REPAIRS.inventory_item_id%type ,
146: job_completed_qty WIP_DISCRETE_JOBS.quantity_completed%type ,
147: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
148: date_completed WIP_DISCRETE_JOBS.date_completed%type,
149: job_item_id WIP_DISCRETE_JOBS.primary_item_id%type,
150: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
151: serial_number_control_code MTL_SYSTEM_ITEMS.serial_number_control_code%type
152:
153: );

Line 163: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,

159: organization_id CSD_REPAIR_JOB_XREF.organization_id%type,
160: allocated_job_qty CSD_REPAIR_JOB_XREF.quantity%type ,
161: wip_entity_id WIP_ENTITIES.wip_entity_id%type,
162: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
163: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
164: creation_date WIP_DISCRETE_JOBS.creation_date%type
165: );
166:
167: --------------------

Line 164: creation_date WIP_DISCRETE_JOBS.creation_date%type

160: allocated_job_qty CSD_REPAIR_JOB_XREF.quantity%type ,
161: wip_entity_id WIP_ENTITIES.wip_entity_id%type,
162: wip_entity_name WIP_ENTITIES.wip_entity_name%type,
163: job_qty WIP_DISCRETE_JOBS.start_quantity%type ,
164: creation_date WIP_DISCRETE_JOBS.creation_date%type
165: );
166:
167: --------------------
168: PROCEDURE check_for_cancelled_order(p_repair_line_id NUMBER);

Line 752: WIP_DISCRETE_JOBS wdj,

748: we.wip_entity_name,
749: mtl.serial_number_control_code
750: from CSD_REPAIR_JOB_XREF crj,
751: CSD_REPAIRS cra,
752: WIP_DISCRETE_JOBS wdj,
753: WIP_ENTITIES we,
754: MTL_SYSTEM_ITEMS mtl
755: where wdj.wip_entity_id = crj.wip_entity_id
756: and we.wip_entity_id = wdj.wip_entity_id

Line 788: WIP_DISCRETE_JOBS wdj,

784: we.wip_entity_name,
785: mtl.serial_number_control_code
786: from CSD_REPAIR_JOB_XREF crj,
787: CSD_REPAIRS cra,
788: WIP_DISCRETE_JOBS wdj,
789: WIP_ENTITIES we,
790: MTL_SYSTEM_ITEMS mtl
791: where wdj.wip_entity_id = crj.wip_entity_id
792: and we.wip_entity_id = wdj.wip_entity_id

Line 927: -- In WIP_DISCRETE_JOBS

923:
924: IF l_remaining_qty > 0 then
925: IF JOB.serial_number_control_code in (2,5) THEN
926: -- Serialized at inventory receipt and Pre-defined
927: -- In WIP_DISCRETE_JOBS
928: -- Job Name Job Id Start Qty Completion Qty Completion Subinv
929: -- W1 1121 10 10
930: --
931: -- MTL_MATERIAL_TRANSACTIONS

Line 1037: -- Wip Discrete Jobs

1033: -- R1 A 1 W1 Sn1
1034: -- R2 A 1 W1 Sn2
1035: -- R3 A 1 W1 Sn3
1036: --
1037: -- Wip Discrete Jobs
1038: -- Job Start Qty Comp Qty
1039: -- W1 3 3
1040: --
1041: -- MTL Material Transactions

Line 1294: -- In WIP_DISCRETE_JOBS

1290: END IF;
1291:
1292: ELSE
1293: -- This scenario is for the serialized item at sales order issue and non-serialized
1294: -- In WIP_DISCRETE_JOBS
1295: -- Job Name Job Id Start Qty Completion Qty Completion Subinv
1296: -- W1 1121 10 10
1297: --
1298: -- MTL_MATERIAL_TRANSACTIONS

Line 1573: wip_discrete_jobs wdj

1569: wdj.start_quantity job_qty,
1570: wdj.creation_date
1571: from CSD_REPAIR_JOB_XREF crj,
1572: WIP_ENTITIES we,
1573: wip_discrete_jobs wdj
1574: where wdj.wip_entity_id = we.wip_entity_id
1575: and crj.job_name = we.wip_entity_name
1576: and crj.organization_id = we.organization_id
1577: and crj.repair_line_id = p_rep_line_id

Line 1593: wip_discrete_jobs wdj

1589: wdj.start_quantity job_qty,
1590: wdj.creation_date
1591: from CSD_REPAIR_JOB_XREF crj,
1592: WIP_ENTITIES we,
1593: wip_discrete_jobs wdj
1594: where wdj.wip_entity_id = we.wip_entity_id
1595: and crj.job_name = we.wip_entity_name
1596: and crj.organization_id = we.organization_id
1597: and crj.wip_entity_id is null;

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

1625: -- for commiting purpose
1626: l_count := 0;
1627:
1628: -- When Jobs are created from the UI, a record is inserted in csd_repair_job_xref
1629: -- with the job name. Once the WIP Job is created in wip_discrete_jobs
1630: -- then the update program will find the wip_entity_id and update it.
1631: -- Also it updates the quantity_in_wip in the csd_repairs with Job start quantity
1632: --
1633: -- When the WIP Job is submitted from the UI, the record would look as follows: