APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_LINES

Line 443: FROM JAI_RCV_LINES

439: CURSOR cur_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
440: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
441: IS
442: SELECT shipment_header_id, shipment_line_id
443: FROM JAI_RCV_LINES
444: WHERE shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)
445: AND shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
446: ORDER BY shipment_line_id;
447:

Line 771: FROM JAI_RCV_LINES a,

767: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
768: IS
769: SELECT a.shipment_line_id, a.transaction_id, a.inventory_item_id, a.receipt_num, b.line_num
770: , excise_invoice_no, excise_invoice_date -- brathod, Bug# 6109941
771: FROM JAI_RCV_LINES a,
772: rcv_shipment_lines b
773: WHERE a.shipment_header_id = b.shipment_header_id
774: AND a.shipment_line_id = b.shipment_line_id
775: AND a.shipment_header_id = NVL(cp_shipment_header_id,a.shipment_header_id)

Line 1098: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,

1094:
1095: PROCEDURE update_rcv_lines(
1096: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1097: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1098: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1099: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1100: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1101: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1102: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',

Line 1901: JAI_RCV_LINES b

1897: SELECT a.vat_invoice_no, a.vat_invoice_date, b.transaction_id, a.tax_transaction_id,
1898: a.excise_invoice_no , a.excise_invoice_Date /*bduvarag Bug5899383*/
1899: ,a.transaction_date /*added by vkaranam for bug#14061440*/
1900: FROM JAI_RCV_TRANSACTIONS a,
1901: JAI_RCV_LINES b
1902: WHERE a.transaction_id = b.transaction_id
1903: AND b.shipment_header_id = cp_shipment_header_id
1904: AND b.shipment_line_id = cp_shipment_line_id;
1905:

Line 2024: UPDATE JAI_RCV_LINES

2020: -- Bug 6109941, Removed update statement of dff attribute columns of
2021: -- RCV_SHIPMENT_HEADERS and RCV_TRASACTIONS tables
2022: --
2023:
2024: UPDATE JAI_RCV_LINES
2025: SET excise_invoice_no = rec_claims.invoice_no,
2026: excise_invoice_Date = rec_claims.invoice_date
2027: WHERE shipment_header_id = rec_claims.shipment_header_id
2028: AND excise_invoice_no IS NULL;