[Home] [Help]
1230: -- Ensures that we process one WIP job at a time.
1231: CURSOR c_eligible_WIP_Jobs IS
1232: SELECT XREF.wip_entity_id, XREF.organization_id WIP_Organization_Id,
1233: XREF.inventory_item_id, XREF.JOB_NAME
1234: FROM CSD_ACTUALS_FROM_WIP_V XREF
1235: WHERE XREF.repair_line_id = p_repair_line_id;
1236:
1237: -- A note on the view CSD_ACTUALS_FROM_WIP_V.
1238: -- 1. It gets all the WIP jobs for an RO that have the
1233: XREF.inventory_item_id, XREF.JOB_NAME
1234: FROM CSD_ACTUALS_FROM_WIP_V XREF
1235: WHERE XREF.repair_line_id = p_repair_line_id;
1236:
1237: -- A note on the view CSD_ACTUALS_FROM_WIP_V.
1238: -- 1. It gets all the WIP jobs for an RO that have the
1239: -- statuses - 4(Complete), 5(Complete - No Charge) and 12(Closed).
1240: -- 2. We opted to also include 'Complete' (NOT in the design) as user
1241: -- cannot update a WIP job status to 'Complete - NC' within Depot
1275: -- 3. The SUM function is intended to cancel out any +ve and -ve qty.
1276: -- 4. If an item, that is same as the Assembly item, is issued/returned
1277: -- to the job then we do not consider it to be a material line.
1278: -- 5. We use primary quantity/UOM and NOT transactional quantity/UOM.
1279: -- 6. The view CSD_ACTUALS_FROM_WIP_V considers only the WIP jobs that have
1280: -- not been imported.
1281:
1282: CURSOR c_actual_lines_from_materials( l_wip_entity_id NUMBER,
1283: l_inventory_item_id NUMBER) IS
1355: -- Points to note are -
1356: -- 1. Resource transactions are represented in WIP transactions table.
1357: -- 2. We assume the 'billable_item_id' to the inventory item for
1358: -- which we create actual lines.
1359: -- 3. The view CSD_ACTUALS_FROM_WIP_V considers only the WIP jobs that have
1360: -- not been imported.
1361: -- 4. We use primary quantity/UOM and NOT transactional quantity/UOM.
1362: -- 5. For resource transactions, we assume, that the txn primary UOM
1363: -- and the billable item is a valid combination for getting the