APPS.CSP_REPAIR_PO_PVT dependencies on CSP_REPAIR_PO_LINES

Line 80: FROM CSP_REPAIR_PO_HEADERS CRH, CSP_REPAIR_PO_LINES CRL

76: PLL.PO_HEADER_ID = POH.PO_HEADER_ID;
77:
78: CURSOR CSP_RESERVED_LINES(L_REPAIR_PO_HEADER_ID NUMBER) IS
79: SELECT CRL.*, CRH.dest_organization_id
80: FROM CSP_REPAIR_PO_HEADERS CRH, CSP_REPAIR_PO_LINES CRL
81: WHERE CRL.REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
82: AND CRL.REPAIR_PO_HEADER_ID = CRH.REPAIR_PO_HEADER_ID;
83:
84: /*

Line 138: FROM CSP_REPAIR_PO_HEADERS CRPH, CSP_REPAIR_PO_LINES CRPL

134: CRPL.quantity defect_qty,
135: CRPL.received_qty defect_received_qty,
136: CRPL.SCRAP_QTY,
137: CRPL.ADJUSTED_QTY
138: FROM CSP_REPAIR_PO_HEADERS CRPH, CSP_REPAIR_PO_LINES CRPL
139: WHERE CRPH.REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
140: AND CRPH.status = 8
141: AND CRPH.repair_po_header_id = CRPL.repair_po_header_id
142: AND CRPL.inventory_item_id = L_SCRAP_ITEM_ID;

Line 768: UPDATE CSP_REPAIR_PO_LINES

764: -- WHERE CURRENT OF CSP_REPAIR_PO_HEADERS;
765: WHERE ROWID = CSP_REPAIR_PO_HEADERS_rec.ROWID;
766: End if;
767:
768: UPDATE CSP_REPAIR_PO_LINES
769: SET RECEIVED_QTY = IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED
770: where repair_po_header_id = CSP_REPAIR_PO_HEADERS_rec.repair_po_header_id
771: and inventory_item_id = IO_QTY_RECEIVED_CHECK_REC.item_id;
772:

Line 782: FROM CSP_REPAIR_PO_LINES

778:
779: Begin
780: SELECT RECEIVED_QTY
781: INTO l_RECEIVED_QTY
782: FROM CSP_REPAIR_PO_LINES
783: WHERE repair_po_header_id = CSP_REPAIR_PO_HEADERS_rec.repair_po_header_id
784: and inventory_item_id = IO_QTY_RECEIVED_CHECK_REC.item_id;
785: Exception
786: when no_data_found then

Line 817: Qty received for this part before in CSP_REPAIR_PO_LINES)

813:
814: /** Create Wip component issue transaction to the job
815: and issue parts qty as
816: (current received qty for this part in PO_REQ_LINES -
817: Qty received for this part before in CSP_REPAIR_PO_LINES)
818: to the existing WIP JOB by Calling CSP_TRANSACTIONS_PUB.TRANSACT_MATERIAL
819: */
820:
821: l_wib_issue_qty := 0;

Line 897: UPDATE CSP_REPAIR_PO_LINES

893: --WHERE CURRENT OF CSP_REPAIR_PO_HEADERS;
894: WHERE ROWID = CSP_REPAIR_PO_HEADERS_rec.ROWID;
895: End if;
896:
897: UPDATE CSP_REPAIR_PO_LINES
898: SET RECEIVED_QTY = NVL(RECEIVED_QTY,0) + nvl(l_wib_issue_qty,0)
899: --SET RECEIVED_QTY = NVL(RECEIVED_QTY,0) + IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED
900: where repair_po_header_id = CSP_REPAIR_PO_HEADERS_rec.repair_po_header_id
901: and inventory_item_id = IO_QTY_RECEIVED_CHECK_REC.item_id;

Line 946: from CSP_REPAIR_PO_LINES

942: AND nvl(PO_REQ_RECEIVED_QTY_rec.quantity_received,0) > 0 then
943:
944: Select sum(nvl(scrap_qty,0) + nvl(adjusted_qty,0))
945: into l_total_scrap_adjust_qty
946: from CSP_REPAIR_PO_LINES
947: where REPAIR_PO_HEADER_ID = CSP_REPAIR_PO_HEADERS_rec.REPAIR_PO_HEADER_ID
948: group by REPAIR_PO_HEADER_ID;
949:
950: l_usable_subinv := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_USABLE_SUBINV');

Line 1317: FROM CSP_REPAIR_PO_HEADERS CRPH, CSP_REPAIR_PO_LINES CRPL

1313: CRPL.quantity defect_qty,
1314: CRPL.received_qty defect_received_qty,
1315: CRPL.SCRAP_QTY,
1316: CRPL.ADJUSTED_QTY
1317: FROM CSP_REPAIR_PO_HEADERS CRPH, CSP_REPAIR_PO_LINES CRPL
1318: WHERE CRPH.REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
1319: AND CRPH.status = 8 --> WIP_JOB created in WIP_ENTITIES table
1320: AND CRPH.repair_po_header_id = CRPL.repair_po_header_id
1321: AND CRPL.inventory_item_id = L_SCRAP_ADJUST_ITEM_ID;

Line 1446: from CSP_REPAIR_PO_LINES

1442: l_defective_subinv := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');
1443:
1444: Select sum(nvl(scrap_qty,0) + nvl(adjusted_qty,0))
1445: into l_total_scrap_adjust_qty
1446: from CSP_REPAIR_PO_LINES
1447: where REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
1448: group by REPAIR_PO_HEADER_ID;
1449:
1450: If CSP_REPAIR_PO_SCRAP_rec.received_qty = CSP_REPAIR_PO_SCRAP_rec.quantity - (L_SCRAP_ADJUST_QTY + l_total_scrap_adjust_qty) then

Line 1681: UPDATE CSP_REPAIR_PO_LINES

1677: WHERE REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID;
1678:
1679: If L_SCRAP_ADJUST_FLAG = 'SCRAP' then
1680:
1681: UPDATE CSP_REPAIR_PO_LINES
1682: SET scrap_qty = nvl(scrap_qty,0) + L_SCRAP_ADJUST_QTY
1683: ,SCRAP_DATE = nvl(p_SCRAP_ADJUST_DATE,sysdate)
1684: WHERE REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
1685: AND inventory_item_id = L_SCRAP_ADJUST_ITEM_ID;

Line 1689: UPDATE CSP_REPAIR_PO_LINES

1685: AND inventory_item_id = L_SCRAP_ADJUST_ITEM_ID;
1686:
1687: Elsif L_SCRAP_ADJUST_FLAG = 'ADJUSTMENT' then
1688:
1689: UPDATE CSP_REPAIR_PO_LINES
1690: SET adjusted_qty = nvl(adjusted_qty,0) + L_SCRAP_ADJUST_QTY
1691: ,ADJUSTMENT_DATE = nvl(p_SCRAP_ADJUST_DATE,sysdate)
1692: WHERE REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
1693: AND inventory_item_id = L_SCRAP_ADJUST_ITEM_ID;