eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_TAX_PKG dependencies on RCV_TRANSACTIONS

Line 86: v_currency_code rcv_transactions.currency_code % TYPE;

82: v_rg_type VARCHAR2(30);
83: v_so_currency oe_order_headers_all.transactional_curr_code % TYPE; -- added
84: v_req_id NUMBER;
85: v_result BOOLEAN;
86: v_currency_code rcv_transactions.currency_code % TYPE;
87: v_currency_conversion_rate rcv_transactions.currency_conversion_rate % TYPE;
88: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. v_attribute1 VARCHAR2(150);
89: --v_attribute2 DATE;
90: --v_attribute3 VARCHAR2(150);

Line 87: v_currency_conversion_rate rcv_transactions.currency_conversion_rate % TYPE;

83: v_so_currency oe_order_headers_all.transactional_curr_code % TYPE; -- added
84: v_req_id NUMBER;
85: v_result BOOLEAN;
86: v_currency_code rcv_transactions.currency_code % TYPE;
87: v_currency_conversion_rate rcv_transactions.currency_conversion_rate % TYPE;
88: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. v_attribute1 VARCHAR2(150);
89: --v_attribute2 DATE;
90: --v_attribute3 VARCHAR2(150);
91: v_range_no JAI_CMN_VENDOR_SITES.excise_duty_range % TYPE;

Line 301: from JAI_RCV_TRANSACTIONS

297: cursor c_fetch_transaction_quantity(p_shipment_header_id number,
298: p_shipment_line_id number ,
299: p_transaction_type varchar2) is
300: select sum(quantity)
301: from JAI_RCV_TRANSACTIONS
302: where shipment_header_id = p_shipment_header_id
303: and shipment_line_id = p_shipment_line_id
304: and transaction_type = p_transaction_type;
305:

Line 506: p_organization_id, --Added by Nagaraj.s for Bug#2692052. This is made as per RCV_TRANSACTIONS.ORGANIZATION_ID so that Joins can be avoided with RCV_TRANSACTIONS

502: p_line_location_id,
503: NULL,
504: lv_mfg_trading, --NVL(v_manufacturing, 'N')||NVL(v_trading, 'N'), /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
505: p_transaction_id, --Added by Nagaraj.s for Bug#2692052.
506: p_organization_id, --Added by Nagaraj.s for Bug#2692052. This is made as per RCV_TRANSACTIONS.ORGANIZATION_ID so that Joins can be avoided with RCV_TRANSACTIONS
507: v_item_id,-- added by Aparajita for Bug#2813244
508: p_creation_date,
509: p_created_by,
510: p_last_update_date,

Line 627: /*lv_mobile_txn_flag rcv_transactions_interface.mobile_txn%TYPE;

623:
624: /* Start Vijay Shankar for Bug#4199929 */
625: lv_tax_change_on_roi_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_open_int_recpts%TYPE;
626: lv_tax_change_on_wms_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_wms_recpts%TYPE;
627: /*lv_mobile_txn_flag rcv_transactions_interface.mobile_txn%TYPE;
628: above declaration fails incase client has a lower BASE VERSION like 11.5.5
629: So modified as below so that the procedure gets compiled. 4252036(4245089)
630: */
631: lv_mobile_txn_flag VARCHAR2(2);

Line 632: lv_open_interace_receipt_flag rcv_transactions_interface.validation_flag%TYPE;

628: above declaration fails incase client has a lower BASE VERSION like 11.5.5
629: So modified as below so that the procedure gets compiled. 4252036(4245089)
630: */
631: lv_mobile_txn_flag VARCHAR2(2);
632: lv_open_interace_receipt_flag rcv_transactions_interface.validation_flag%TYPE;
633: lv_dynamic_sql VARCHAR2(1000);
634: lv_profile_val VARCHAR2(10);
635:
636: CURSOR c_interface_trx_dtl(cp_interface_transaction_id IN NUMBER) IS

Line 639: FROM rcv_transactions_interface

635:
636: CURSOR c_interface_trx_dtl(cp_interface_transaction_id IN NUMBER) IS
637: /* SELECT nvl(validation_flag, 'N') validation_flag commented by Vijay Shankar for bug#4240265 */
638: SELECT decode(header_interface_id, null, 'N', 'Y') imported_receipt_flag
639: FROM rcv_transactions_interface
640: WHERE interface_transaction_id = cp_interface_transaction_id;
641: /* End Vijay Shankar for Bug#4199929 */
642:
643: CURSOR c_iproc_profile IS

Line 675: lv_dynamic_sql := 'select nvl(mobile_txn, ''N'') mobile_txn FROM rcv_transactions_interface WHERE interface_transaction_id = :1';

671: END LOOP;
672:
673: /* Start, Vijay Shankar for Bug#4199929 */
674: /* following is written to give control to clients so that for open interface receipts the value returned is 'Y' */
675: lv_dynamic_sql := 'select nvl(mobile_txn, ''N'') mobile_txn FROM rcv_transactions_interface WHERE interface_transaction_id = :1';
676: BEGIN
677: execute immediate lv_dynamic_sql into lv_mobile_txn_flag using p_interface_transaction_id;
678: EXCEPTION
679: WHEN OTHERS THEN

Line 900: from RCV_Transactions, which resulted in Mutation Error. Also, according to the URM

896:
897: 8 25/09/2002 Changed by Nagaraj.s for Bug2588096
898: In case of an Unordered Receipt, there was a call to rg23_part_i_entry procedure
899: which in turn makes a call to ja_in_receipt_rg_pkg which had a select statement
900: from RCV_Transactions, which resulted in Mutation Error. Also, according to the URM
901: no RG Entries should happen at the point of Unordered Receipts and hence the coding
902: which was previously calling rg23_part_i_entry is commented and this has resulted in
903: Mutation Trigger being avoided. And also the same coding has been written in
904: the case where Transaction Type is Match. And also previously Tax Lines were inserted

Line 1049: the values in the DFF of RCV_SHIPMENT_HEADERS or RCV_TRANSACTIONS, it was observed that

1045:
1046: 26. 18/06/2004 ssumaith - bug# 3683666 - File Version 115.2
1047:
1048: When a RMA receipt is done without navigating from Receipts-localised form and not entering
1049: the values in the DFF of RCV_SHIPMENT_HEADERS or RCV_TRANSACTIONS, it was observed that
1050: taxes are not defaulted into localization tables (JAI_RCV_LINE_TAXES).
1051: The reason this was happening is because the if condition which was checking this to be a
1052: RMA receipt was also checking the chk_form to be not null with an "AND" to other required
1053: conditions. Hence the problem

Line 1159: Information from the lines DFF is captured into the rcv_transactions table.

1155: When a user creates a new receipt against a purchase order, he needs to enter the following information
1156: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
1157: This DFF is provided at two places, header and line.
1158: Information from the header DFF is captured into the rcv_shipment_headers table.
1159: Information from the lines DFF is captured into the rcv_transactions table.
1160: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
1161: At this time, a facility has been provided for the user to default the information
1162: given at the header level DFF to all the lines only if these columns are null at the
1163: line level. Else the information in the line level DFF is sustained.

Line 1160: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.

1156: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
1157: This DFF is provided at two places, header and line.
1158: Information from the header DFF is captured into the rcv_shipment_headers table.
1159: Information from the lines DFF is captured into the rcv_transactions table.
1160: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
1161: At this time, a facility has been provided for the user to default the information
1162: given at the header level DFF to all the lines only if these columns are null at the
1163: line level. Else the information in the line level DFF is sustained.
1164: For this NVL conditions have been added where this information gets defaulted.