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 140: FROM CSP_REPAIR_PO_HEADERS CRPH, CSP_REPAIR_PO_LINES CRPL

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

Line 918: UPDATE CSP_REPAIR_PO_LINES

914: -- WHERE CURRENT OF CSP_REPAIR_PO_HEADERS;
915: WHERE ROWID = CSP_REPAIR_PO_HEADERS_rec.ROWID;
916: End if;
917:
918: UPDATE CSP_REPAIR_PO_LINES
919: SET RECEIVED_QTY = IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED
920: where repair_po_header_id = CSP_REPAIR_PO_HEADERS_rec.repair_po_header_id
921: and inventory_item_id = IO_QTY_RECEIVED_CHECK_REC.item_id;
922:

Line 932: FROM CSP_REPAIR_PO_LINES

928:
929: Begin
930: SELECT RECEIVED_QTY
931: INTO l_RECEIVED_QTY
932: FROM CSP_REPAIR_PO_LINES
933: WHERE repair_po_header_id = CSP_REPAIR_PO_HEADERS_rec.repair_po_header_id
934: and inventory_item_id = IO_QTY_RECEIVED_CHECK_REC.item_id;
935: Exception
936: when no_data_found then

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

975:
976: /** Create Wip component issue transaction to the job
977: and issue parts qty as
978: (current received qty for this part in PO_REQ_LINES -
979: Qty received for this part before in CSP_REPAIR_PO_LINES)
980: to the existing WIP JOB by Calling CSP_TRANSACTIONS_PUB.TRANSACT_MATERIAL
981: */
982:
983: l_wib_issue_qty := 0;

Line 1066: UPDATE CSP_REPAIR_PO_LINES

1062: --WHERE CURRENT OF CSP_REPAIR_PO_HEADERS;
1063: WHERE ROWID = CSP_REPAIR_PO_HEADERS_rec.ROWID;
1064: End if;
1065:
1066: UPDATE CSP_REPAIR_PO_LINES
1067: SET RECEIVED_QTY = NVL(RECEIVED_QTY,0) + nvl(l_wib_issue_qty,0)
1068: --SET RECEIVED_QTY = NVL(RECEIVED_QTY,0) + IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED
1069: where repair_po_header_id = CSP_REPAIR_PO_HEADERS_rec.repair_po_header_id
1070: and inventory_item_id = IO_QTY_RECEIVED_CHECK_REC.item_id;

Line 1182: from CSP_REPAIR_PO_LINES

1178:
1179: /*
1180: Select sum(nvl(scrap_qty,0) + nvl(adjusted_qty,0))
1181: into l_total_scrap_adjust_qty
1182: from CSP_REPAIR_PO_LINES
1183: where REPAIR_PO_HEADER_ID = CSP_REPAIR_PO_HEADERS_rec.REPAIR_PO_HEADER_ID
1184: group by REPAIR_PO_HEADER_ID;
1185: */
1186:

Line 1579: FROM CSP_REPAIR_PO_HEADERS CRPH, CSP_REPAIR_PO_LINES CRPL

1575: CRPL.quantity defect_qty,
1576: CRPL.received_qty defect_received_qty,
1577: CRPL.SCRAP_QTY,
1578: CRPL.ADJUSTED_QTY
1579: FROM CSP_REPAIR_PO_HEADERS CRPH, CSP_REPAIR_PO_LINES CRPL
1580: WHERE CRPH.REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
1581: AND CRPH.status = 8 --> WIP_JOB created in WIP_ENTITIES table
1582: AND CRPH.repair_po_header_id = CRPL.repair_po_header_id
1583: AND CRPL.inventory_item_id = L_SCRAP_ADJUST_ITEM_ID;

Line 1744: from CSP_REPAIR_PO_LINES

1740: l_defective_subinv := FND_PROFILE.value(NAME => 'CSP_REPAIR_SUP_ORG_DEFECT_SUBINV');
1741:
1742: Select sum(nvl(scrap_qty,0) + nvl(adjusted_qty,0))
1743: into l_total_scrap_adjust_qty
1744: from CSP_REPAIR_PO_LINES
1745: where REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID
1746: group by REPAIR_PO_HEADER_ID;
1747:
1748: If NVL(CSP_REPAIR_PO_SCRAP_rec.received_qty,0) = CSP_REPAIR_PO_SCRAP_rec.quantity - (L_SCRAP_ADJUST_QTY + l_total_scrap_adjust_qty) then

Line 1986: UPDATE CSP_REPAIR_PO_LINES

1982: WHERE REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID;
1983:
1984: If L_SCRAP_ADJUST_FLAG = 'SCRAP' then
1985:
1986: UPDATE CSP_REPAIR_PO_LINES
1987: SET scrap_qty = nvl(scrap_qty,0) + L_SCRAP_ADJUST_QTY
1988: ,SCRAP_DATE = nvl(p_SCRAP_ADJUST_DATE,sysdate)
1989: ,reason_id = l_reason_id
1990: WHERE REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID

Line 1995: UPDATE CSP_REPAIR_PO_LINES

1991: AND inventory_item_id = L_SCRAP_ADJUST_ITEM_ID;
1992:
1993: Elsif L_SCRAP_ADJUST_FLAG = 'NEGATIVE ADJUSTMENT' then
1994:
1995: UPDATE CSP_REPAIR_PO_LINES
1996: SET adjusted_qty = nvl(adjusted_qty,0) + L_SCRAP_ADJUST_QTY
1997: ,ADJUSTMENT_DATE = nvl(p_SCRAP_ADJUST_DATE,sysdate)
1998: ,reason_id = l_reason_id
1999: WHERE REPAIR_PO_HEADER_ID = L_REPAIR_PO_HEADER_ID