APPS.JAI_PO_HOOK_PKG dependencies on RCV_TRANSACTIONS

Line 106: FROM RCV_TRANSACTIONS

102: WHERE requisition_header_id = p_header_id;
103:
104: CURSOR rcpt_cur IS
105: SELECT *
106: FROM RCV_TRANSACTIONS
107: WHERE shipment_header_id = p_header_id
108: AND shipment_line_id = p_line_id
109: AND transaction_type = 'RECEIVE';
110:

Line 144: RCV_TRANSACTIONS_INTERFACE rtxns,

140: -- rtxns.CURRENCY_CONVERSION_RATE, /*rchandan for 5961325*/
141: -- rtxns.CURRENCY_CONVERSION_DATE, /*rchandan for 5961325*/
142: poll.org_id /*rchandan for 5961325*/
143: FROM JAI_CMN_LINES lines,
144: RCV_TRANSACTIONS_INTERFACE rtxns,
145: po_line_locations_all poll
146: WHERE lines.interface_transaction_id =
147: rtxns.interface_transaction_id
148: AND lines.HEADER_INTERFACE_ID = rtxns.HEADER_INTERFACE_ID

Line 679: UPDATE rcv_transactions

675: END calc_taxes;
676:
677: PROCEDURE update_rcv_trxs(P_transaction_id IN NUMBER) IS
678: BEGIN
679: UPDATE rcv_transactions
680: SET attribute4 = 'Y', attribute_category = 'India Return to Vendor'
681: WHERE transaction_id = P_transaction_id;
682:
683: END update_rcv_trxs;

Line 725: UPDATE JAI_RCV_TRANSACTIONS

721: ELSIF p_process_Action = 'N' THEN
722: lv_process_flag := 'P';
723: END IF;
724:
725: UPDATE JAI_RCV_TRANSACTIONS
726: SET process_status = lv_process_flag,
727: cenvat_rg_status = lv_process_flag,
728: cenvat_rg_message = NULL,
729: process_vat_status = lv_process_flag

Line 957: from rcv_transactions_interface

953: retcode OUT NOCOPY VARCHAR2
954: ) IS
955: CURSOR c_txns_interface(cp_hdr_intf_id IN NUMBER) IS
956: /*select *
957: from rcv_transactions_interface
958: where HEADER_INTERFACE_ID = cp_hdr_intf_id;*/
959: SELECT rtxn.*,
960: (SELECT currency_code
961: FROM po_headers_all

Line 966: FROM rcv_transactions_interface rtxn

962: WHERE po_header_id = rtxn.po_header_id) CUR_CODE,
963: (SELECT quantity
964: FROM po_line_locations_all
965: WHERE LINE_LOCATION_ID = rtxn.PO_LINE_LOCATION_ID) TOT_QUANTITY
966: FROM rcv_transactions_interface rtxn
967: WHERE rtxn.HEADER_INTERFACE_ID = cp_hdr_intf_id;
968:
969: CURSOR c_hdr_interface(cp_hdr_intf_id IN NUMBER) IS
970: SELECT shipment_num

Line 1154: UPDATE RCV_TRANSACTIONS_INTERFACE

1150: retcode OUT NOCOPY VARCHAR2
1151: ) IS
1152: lv_attr_categ VARCHAR2(30) := 'India Receipt';
1153: BEGIN
1154: UPDATE RCV_TRANSACTIONS_INTERFACE
1155: SET ATTRIBUTE_CATEGORY = lv_attr_categ,
1156: ATTRIBUTE1 = p_invoice_num,
1157: ATTRIBUTE2 = P_invoice_date
1158: WHERE INTERFACE_TRANSACTION_ID = P_transaction_id;

Line 1215: FROM rcv_transactions

1211: WHERE requisition_line_id = cp_reqn_line_id;
1212: /* Get the conversion rate for the currency code for the receipt shipment line */
1213: CURSOR c_conv_rate_rcpt(cp_shipment_line_id IN NUMBER) IS
1214: SELECT currency_conversion_rate, currency_code
1215: FROM rcv_transactions
1216: WHERE shipment_line_id = cp_shipment_line_id
1217: AND transaction_type = 'RECEIVE';
1218: /* Get the RFQ / PO / BPA tax amount for each line location currency code wise*/
1219: CURSOR c_po_rfq IS

Line 1740: UPDATE RCV_TRANSACTIONS_INTERFACE

1736: SET PROCESSING_STATUS_CODE = 'IL_PENDING'
1737: WHERE header_interface_id = lv_header_id
1738: AND PROCESSING_STATUS_CODE = 'PENDING';
1739:
1740: UPDATE RCV_TRANSACTIONS_INTERFACE
1741: SET PROCESSING_STATUS_CODE = 'IL_PENDING'
1742: WHERE header_interface_id = lv_header_id
1743: AND PROCESSING_STATUS_CODE = 'PENDING';
1744:

Line 1752: UPDATE RCV_TRANSACTIONS_INTERFACE

1748: SET PROCESSING_STATUS_CODE = 'PENDING'
1749: WHERE header_interface_id = lv_header_id
1750: AND PROCESSING_STATUS_CODE = 'IL_PENDING';
1751:
1752: UPDATE RCV_TRANSACTIONS_INTERFACE
1753: SET PROCESSING_STATUS_CODE = 'PENDING'
1754: WHERE header_interface_id = lv_header_id
1755: AND PROCESSING_STATUS_CODE = 'IL_PENDING';
1756:

Line 1862: FROM jai_rcv_transactions

1858: 'CORRECT',
1859: Decode(parent_transaction_type,'RECEIVE',quantity,
1860: 'RETURN TO VENDOR',-1*quantity,0),
1861: 0))
1862: FROM jai_rcv_transactions
1863: WHERE shipment_header_id = p_shid
1864: AND shipment_line_id = p_slid;
1865:
1866: CURSOR c_rec_qty (p_shid NUMBER, p_slid NUMBER) IS

Line 1868: FROM jai_rcv_transactions

1864: AND shipment_line_id = p_slid;
1865:
1866: CURSOR c_rec_qty (p_shid NUMBER, p_slid NUMBER) IS
1867: SELECT Sum(quantity)
1868: FROM jai_rcv_transactions
1869: WHERE shipment_header_id=p_shid
1870: AND shipment_line_id=p_slid
1871: AND transaction_type='RECEIVE';
1872:

Line 2364: FROM rcv_transactions

2360: CURSOR conv_rate_rcpt_csr(pn_shipment_line_id IN NUMBER) IS
2361: SELECT
2362: currency_conversion_rate
2363: , currency_code
2364: FROM rcv_transactions
2365: WHERE shipment_line_id = pn_shipment_line_id
2366: AND transaction_type = 'RECEIVE';
2367:
2368: --Get the RFQ / PO / BPA tax amount for each line location currency code