[Home] [Help]
1208: -- Ensures that we process one WIP job at a time.
1209: CURSOR c_eligible_WIP_Jobs IS
1210: SELECT XREF.wip_entity_id, XREF.organization_id WIP_Organization_Id,
1211: XREF.inventory_item_id, XREF.JOB_NAME
1212: FROM CSD_ACTUALS_FROM_WIP_V XREF
1213: WHERE XREF.repair_line_id = p_repair_line_id;
1214:
1215: -- A note on the view CSD_ACTUALS_FROM_WIP_V.
1216: -- 1. It gets all the WIP jobs for an RO that have the
1211: XREF.inventory_item_id, XREF.JOB_NAME
1212: FROM CSD_ACTUALS_FROM_WIP_V XREF
1213: WHERE XREF.repair_line_id = p_repair_line_id;
1214:
1215: -- A note on the view CSD_ACTUALS_FROM_WIP_V.
1216: -- 1. It gets all the WIP jobs for an RO that have the
1217: -- statuses - 4(Complete), 5(Complete - No Charge) and 12(Closed).
1218: -- 2. We opted to also include 'Complete' (NOT in the design) as user
1219: -- cannot update a WIP job status to 'Complete - NC' within Depot
1253: -- 3. The SUM function is intended to cancel out any +ve and -ve qty.
1254: -- 4. If an item, that is same as the Assembly item, is issued/returned
1255: -- to the job then we do not consider it to be a material line.
1256: -- 5. We use primary quantity/UOM and NOT transactional quantity/UOM.
1257: -- 6. The view CSD_ACTUALS_FROM_WIP_V considers only the WIP jobs that have
1258: -- not been imported.
1259:
1260: CURSOR c_actual_lines_from_materials( l_wip_entity_id NUMBER,
1261: l_inventory_item_id NUMBER) IS
1298: -- Points to note are -
1299: -- 1. Resource transactions are represented in WIP transactions table.
1300: -- 2. We assume the 'billable_item_id' to the inventory item for
1301: -- which we create actual lines.
1302: -- 3. The view CSD_ACTUALS_FROM_WIP_V considers only the WIP jobs that have
1303: -- not been imported.
1304: -- 4. We use primary quantity/UOM and NOT transactional quantity/UOM.
1305: -- 5. For resource transactions, we assume, that the txn primary UOM
1306: -- and the billable item is a valid combination for getting the