APPS.QA_SKIPLOT_RES_ENGINE dependencies on QA_SKIPLOT_RCV_RESULTS

Line 529: select 'FINISHED' from qa_skiplot_rcv_results

525: p_txn_qty in number,
526: p_shipment_line_id in number) return varchar2 is
527:
528: cursor c (x_txn_qty number, x_shl_id number) is
529: select 'FINISHED' from qa_skiplot_rcv_results
530: where shipment_line_id = x_shl_id and
531: lot_qty <= transacted_qty + nvl(x_txn_qty, 0) ;
532:
533: conclusion varchar2(20);

Line 575: from qa_skiplot_rcv_results

571: pid number;
572:
573: cursor get_receipt_date (x_insp_lot_id number) is
574: select receipt_date
575: from qa_skiplot_rcv_results
576: where insp_lot_id = x_insp_lot_id;
577:
578: cursor get_receipt_date2 (x_shl_id number) is
579: select receipt_date

Line 580: from qa_skiplot_rcv_results

576: where insp_lot_id = x_insp_lot_id;
577:
578: cursor get_receipt_date2 (x_shl_id number) is
579: select receipt_date
580: from qa_skiplot_rcv_results
581: where shipment_line_id = x_shl_id;
582:
583: --
584: -- given a criteria_id, lotsize and receipt date

Line 835: from qa_skiplot_rcv_results

831:
832:
833: cursor shls (x_lpn_id number) is
834: select shipment_line_id
835: from qa_skiplot_rcv_results
836: where lpn_id = x_lpn_id;
837:
838: shlid number;
839: lot_result varchar2(30);

Line 1009: ' FROM rcv_supply rs, rcv_transactions rt,qa_skiplot_rcv_results qsrr , PO_HEADERS_TRX_V ph '||

1005: -- bug 9652549 CLM changes
1006: --
1007: shls_query :=
1008: ' SELECT distinct rs.shipment_line_id ' ||
1009: ' FROM rcv_supply rs, rcv_transactions rt,qa_skiplot_rcv_results qsrr , PO_HEADERS_TRX_V ph '||
1010: ' WHERE rs.rcv_transaction_id = rt.transaction_id ' ||
1011: ' AND rs.po_header_id = ph.po_header_id ' ||
1012: ' AND ph.segment1 = :1 ' ||
1013: ' AND rs.to_organization_id = :2 ' ||

Line 1439: to identify a unique row in qa_skiplot_rcv_results. The existing

1435: would be fetched) when skiplot is done for ASN's. So using the new
1436: parameters p_shipment_header_id, p_rcv_txn_id and the existing
1437: p_shipment_line_id we can identify the interface_transaction_id
1438: which in turn can be used in combination with p_shipment_line_id
1439: to identify a unique row in qa_skiplot_rcv_results. The existing
1440: update statement would work for Receipts against Purchase Orders
1441: in which seperate shipment line will be created for each Receipt.
1442:
1443: In the where clause i have used "interface_txn_id IS NULL" to prevent

Line 1493: update qa_skiplot_rcv_results

1489: NULL;
1490: END;
1491: END IF;
1492:
1493: update qa_skiplot_rcv_results
1494: set inspection_status = lot_status,
1495: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1496: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1497: transacted_qty = decode (p_reinsp_flag, fnd_api.g_true, transacted_qty,

Line 1510: update qa_skiplot_rcv_results

1506: returning criteria_id, inspection_result into c_id, lot_result;
1507:
1508: /* End of inclusion for bug 8678609. */
1509: else
1510: update qa_skiplot_rcv_results
1511: set inspection_status = lot_status,
1512: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1513: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1514: transacted_qty = decode(p_reinsp_flag, fnd_api.g_true, transacted_qty,