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 323: from JAI_RCV_TRANSACTIONS

319: cursor c_fetch_transaction_quantity(p_shipment_header_id number,
320: p_shipment_line_id number ,
321: p_transaction_type varchar2) is
322: select sum(quantity)
323: from JAI_RCV_TRANSACTIONS
324: where shipment_header_id = p_shipment_header_id
325: and shipment_line_id = p_shipment_line_id
326: and transaction_type = p_transaction_type;
327:

Line 583: 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

579: p_line_location_id,
580: NULL,
581: lv_mfg_trading, --NVL(v_manufacturing, 'N')||NVL(v_trading, 'N'), /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
582: p_transaction_id, --Added by Nagaraj.s for Bug#2692052.
583: 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
584: v_item_id,-- added by Aparajita for Bug#2813244
585: p_creation_date,
586: p_created_by,
587: p_last_update_date,

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

700:
701: /* Start Vijay Shankar for Bug#4199929 */
702: lv_tax_change_on_roi_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_open_int_recpts%TYPE;
703: lv_tax_change_on_wms_recpts JAI_CMN_INVENTORY_ORGS.tax_change_on_wms_recpts%TYPE;
704: /*lv_mobile_txn_flag rcv_transactions_interface.mobile_txn%TYPE;
705: above declaration fails incase client has a lower BASE VERSION like 11.5.5
706: So modified as below so that the procedure gets compiled. 4252036(4245089)
707: */
708: lv_mobile_txn_flag VARCHAR2(2);

Line 709: lv_open_interace_receipt_flag rcv_transactions_interface.validation_flag%TYPE;

705: above declaration fails incase client has a lower BASE VERSION like 11.5.5
706: So modified as below so that the procedure gets compiled. 4252036(4245089)
707: */
708: lv_mobile_txn_flag VARCHAR2(2);
709: lv_open_interace_receipt_flag rcv_transactions_interface.validation_flag%TYPE;
710: lv_dynamic_sql VARCHAR2(1000);
711: lv_profile_val VARCHAR2(10);
712:
713: CURSOR c_interface_trx_dtl(cp_interface_transaction_id IN NUMBER) IS

Line 715: * from rcv_transactions_interface. We should check rcv_headers_interface table instead,

711: lv_profile_val VARCHAR2(10);
712:
713: CURSOR c_interface_trx_dtl(cp_interface_transaction_id IN NUMBER) IS
714: /*cursor query changed for bug 8486273 - on successful import, rows will be deleted
715: * from rcv_transactions_interface. We should check rcv_headers_interface table instead,
716: * where data would be retained until being purged. It should be noted that the group_id
717: * link between rcv_transactions and rcv_headers_interface is not one-one, but it is enough
718: * to establish that the receipt is imported through open interface.
719: bug 8594501 - earlier query caused mutating table error, as it hit the rcv_transactions

Line 717: * link between rcv_transactions and rcv_headers_interface is not one-one, but it is enough

713: CURSOR c_interface_trx_dtl(cp_interface_transaction_id IN NUMBER) IS
714: /*cursor query changed for bug 8486273 - on successful import, rows will be deleted
715: * from rcv_transactions_interface. We should check rcv_headers_interface table instead,
716: * where data would be retained until being purged. It should be noted that the group_id
717: * link between rcv_transactions and rcv_headers_interface is not one-one, but it is enough
718: * to establish that the receipt is imported through open interface.
719: bug 8594501 - earlier query caused mutating table error, as it hit the rcv_transactions
720: * table for the same row which triggered this procedure (not committed yet). For this,
721: * group_id is being passed as a procedure parameter from the trigger.*/

Line 719: bug 8594501 - earlier query caused mutating table error, as it hit the rcv_transactions

715: * from rcv_transactions_interface. We should check rcv_headers_interface table instead,
716: * where data would be retained until being purged. It should be noted that the group_id
717: * link between rcv_transactions and rcv_headers_interface is not one-one, but it is enough
718: * to establish that the receipt is imported through open interface.
719: bug 8594501 - earlier query caused mutating table error, as it hit the rcv_transactions
720: * table for the same row which triggered this procedure (not committed yet). For this,
721: * group_id is being passed as a procedure parameter from the trigger.*/
722: /* Code added from the above bugs needs to be Reverted as they are not supported in R12*/
723: --SELECT nvl(validation_flag, 'N') validation_flag commented by Vijay Shankar for bug#4240265

Line 725: FROM rcv_transactions_interface

721: * group_id is being passed as a procedure parameter from the trigger.*/
722: /* Code added from the above bugs needs to be Reverted as they are not supported in R12*/
723: --SELECT nvl(validation_flag, 'N') validation_flag commented by Vijay Shankar for bug#4240265
724: SELECT decode(header_interface_id, null, 'N', 'Y') imported_receipt_flag
725: FROM rcv_transactions_interface
726: WHERE interface_transaction_id = cp_interface_transaction_id;
727: /*End Vijay Shankar for Bug#4199929 */
728: /* Reverted the change in R12 Query added by nprashar for bug # 8566481
729: SELECT 'Y'

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

763: END LOOP;
764:
765: /* Start, Vijay Shankar for Bug#4199929 */
766: /* following is written to give control to clients so that for open interface receipts the value returned is 'Y' */
767: lv_dynamic_sql := 'select nvl(mobile_txn, ''N'') mobile_txn FROM rcv_transactions_interface WHERE interface_transaction_id = :1';
768: BEGIN
769: execute immediate lv_dynamic_sql into lv_mobile_txn_flag using p_interface_transaction_id;
770: EXCEPTION
771: WHEN OTHERS THEN

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

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

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

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

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

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

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

1248: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
1249: This DFF is provided at two places, header and line.
1250: Information from the header DFF is captured into the rcv_shipment_headers table.
1251: Information from the lines DFF is captured into the rcv_transactions table.
1252: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
1253: At this time, a facility has been provided for the user to default the information
1254: given at the header level DFF to all the lines only if these columns are null at the
1255: line level. Else the information in the line level DFF is sustained.
1256: For this NVL conditions have been added where this information gets defaulted.