[Home] [Help]
7580:
7581:
7582: -- It forms the outer most loop for the processing.
7583: -- Ensures that we process one WIP job at a time.
7584: -- A note on the view CSD_ESTIMATES_FROM_WIP_V.
7585: -- 1. It gets all the WIP jobs for an RO that have the
7586: -- statuses - 1 Unreleased, 3 Released
7587: -- 2. The view makes sure that any WIP jobs that is/are shared
7588: -- with other repair orders are not fetched.
7588: -- with other repair orders are not fetched.
7589: CURSOR c_eligible_WIP_Jobs IS
7590: SELECT XREF.wip_entity_id, XREF.organization_id WIP_Organization_Id,
7591: XREF.inventory_item_id, XREF.JOB_NAME
7592: FROM CSD_ESTIMATES_FROM_WIP_V XREF
7593: WHERE XREF.repair_line_id = p_repair_line_id;
7594:
7595:
7596: -- Gets all the WIP jobs for the repair order that are
7620: -- 3. The SUM function is intended to cancel out any +ve and -ve qty.
7621: -- 4. If an item, that is same as the Assembly item, is issued/returned
7622: -- to the job then we do not consider it to be a material line.
7623: -- 5. We use primary quantity/UOM and NOT transactional quantity/UOM.
7624: -- 6. The view CSD_ESTIMATES_FROM_WIP_V considers only the WIP jobs that have
7625: -- not been imported.
7626:
7627: -- this query gets the net qty for materials
7628: CURSOR c_est_lines_from_materials( l_wip_entity_id NUMBER,
7725: -- Points to note are -
7726: -- 1. Resource transactions are represented in WIP transactions table.
7727: -- 2. We assume the 'billable_item_id' to the inventory item for
7728: -- which we create estimate lines.
7729: -- 3. The view CSD_ESTIMATES_FROM_WIP_V considers only the WIP jobs that have
7730: -- not been imported.
7731: -- 4. We use primary quantity/UOM and NOT transactional quantity/UOM.
7732: -- 5. For resource transactions, we assume, that the txn primary UOM
7733: -- and the billable item is a valid combination for getting the