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_SHIPMENT_HEADERS

Line 58: v_receipt_num rcv_shipment_headers.receipt_num % TYPE;

54: /* Added by Ramananda for bug# exc_objects */
55: lv_object_name CONSTANT VARCHAR2(61) := 'jai_rcv_tax_pkg.default_taxes_onto_line';
56:
57: -- LAST MODIFIED BY SRIHARI on 25-JUN-2000
58: v_receipt_num rcv_shipment_headers.receipt_num % TYPE;
59: v_loc_quantity po_line_locations_all.quantity % TYPE;
60: v_cor_amount JAI_PO_LINE_LOCATIONS.tax_amount % TYPE;
61: -- v_form_id VARCHAR2(30); --File.Sql.35 Cbabu := 'JAINPORE';
62: v_chk_form VARCHAR2(30);

Line 74: v_receipt_source_code rcv_shipment_headers.receipt_source_code % TYPE;

70: v_item_id rcv_shipment_lines.item_id % TYPE;
71: v_organization_id rcv_shipment_lines.to_organization_id % TYPE;
72: v_item_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE;
73: v_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag % TYPE;
74: v_receipt_source_code rcv_shipment_headers.receipt_source_code % TYPE;
75: -- v_paddr v$session.paddr % TYPE;
76: -- v_temp_status ja_in_temp_receipt.status % TYPE; --Commented by Nagaraj.s for Bug#2692052
77: v_paddr RAW(32); /*Bug 4644524 bduvarag*/
78: v_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE; --Changed the %type by Nagaraj.s for Bug#2692052

Line 100: v_rsh_organization_id rcv_shipment_headers.organization_id % TYPE;

96: v_conv_factor NUMBER;
97: v_register_type JAI_CMN_RG_23AC_I_TRXS.register_type % TYPE;
98: v_duplicate_ship VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
99: v_picking_line_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE; --added
100: v_rsh_organization_id rcv_shipment_headers.organization_id % TYPE;
101: v_internal_vendor JAI_CMN_TAXES_ALL.vendor_id % TYPE;
102: v_current_tax NUMBER;
103: v_trading JAI_CMN_INVENTORY_ORGS.trading % TYPE;
104: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing % TYPE;

Line 277: FROM rcv_shipment_headers

273: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. CURSOR c_hdr_attribute5(p_shipment_header_id IN NUMBER) IS
274: CURSOR c_hdr_dtl(p_shipment_header_id IN NUMBER) IS
275: SELECT -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. attribute5,
276: shipment_num
277: FROM rcv_shipment_headers
278: WHERE shipment_header_id = p_shipment_header_id;
279:
280: --Added by Sanjikum for Bug#4533114
281: CURSOR c_hdr_attribute5_1(p_delivery_name VARCHAR2)

Line 302: v_shipment_num rcv_shipment_headers.shipment_num%type; -- ssumaith - bug# 3657662

298: -- bug 4516678. Added by Lakshmi Gopalsami
299: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
300:
301: v_express VARCHAR2(100);
302: v_shipment_num rcv_shipment_headers.shipment_num%type; -- ssumaith - bug# 3657662
303: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662
304:
305: cursor c_order_cur (p_shipment_num rcv_shipment_headers.shipment_num%type) is
306: select order_header_id

Line 305: cursor c_order_cur (p_shipment_num rcv_shipment_headers.shipment_num%type) is

301: v_express VARCHAR2(100);
302: v_shipment_num rcv_shipment_headers.shipment_num%type; -- ssumaith - bug# 3657662
303: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662
304:
305: cursor c_order_cur (p_shipment_num rcv_shipment_headers.shipment_num%type) is
306: select order_header_id
307: from JAI_OM_WSH_LINES_ALL
308: where delivery_id = p_shipment_num;
309:

Line 387: from rcv_shipment_headers

383:
384:
385: cursor c_check_asbn is
386: SELECT '1' , shipment_num
387: from rcv_shipment_headers
388: where shipment_header_id = p_shipment_header_id
389: And asn_type = 'ASBN';
390:
391:

Line 504: rcv_shipment_headers RSH

500: IS
501: SELECT
502: '1'
503: FROM
504: rcv_shipment_headers RSH
505: WHERE
506: RSH.shipment_header_id = p_shipment_header_id
507: AND asn_type = 'ASN';
508: lv_asn_type VARCHAR2(1);

Line 1091: of EXPRESS Receipt. This change is made as the PADDR concept is removed in RCV_SHIPMENT_HEADERS DFF.

1087: table.
1088:
1089: 17. 21/07/2003 Vijay Shankar for Bug# 3028040, Version : 616.2
1090: Code is added to check for EXPRESS transaction and then stop 'For Passing' to fire for every RECEIVE transaction
1091: of EXPRESS Receipt. This change is made as the PADDR concept is removed in RCV_SHIPMENT_HEADERS DFF.
1092:
1093: 18. 29/07/2003 Nagaraj.s for Bug #2993865 . Version#:616.3
1094: The two queries which were written earlier to fetch line_id,transaction_curr_code,
1095: delivery_detail_id have been merged to form one query.

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 1250: Information from the header DFF is captured into the rcv_shipment_headers table.

1246:
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

Line 1640: FROM rcv_shipment_headers

1636: END IF;
1637:
1638: FOR row_rec IN (SELECT ROWID,
1639: organization_id
1640: FROM rcv_shipment_headers
1641: WHERE shipment_header_id = p_shipment_header_id)
1642: LOOP
1643: -- v_rowid := row_rec.ROWID;
1644: v_rsh_organization_id := row_rec.organization_id;

Line 1747: FROM rcv_shipment_headers

1743: --End Added by Ramananda for Bug#4533114
1744:
1745: -------------------------------- To retrieve receipt number ---------------------------------
1746: FOR header_rec IN (SELECT receipt_num
1747: FROM rcv_shipment_headers
1748: WHERE shipment_header_id = p_shipment_header_id)
1749: LOOP
1750: v_receipt_num := header_rec.receipt_num;
1751: END LOOP;

Line 1759: FROM rcv_shipment_headers

1755: END IF;
1756:
1757: IF p_transaction_type = 'RECEIVE' THEN
1758: FOR head_rec IN (SELECT receipt_source_code
1759: FROM rcv_shipment_headers
1760: WHERE shipment_header_id = p_shipment_header_id)
1761: LOOP
1762: v_receipt_source_code := head_rec.receipt_source_code;
1763: END LOOP;

Line 4184: rcv_shipment_headers rsh

4180: oe_order_headers_all sha,
4181: po_requisition_headers_all prha,
4182: po_requisition_lines_all prla,
4183: JAI_OM_WSH_LINES_ALL spl,
4184: rcv_shipment_headers rsh
4185:
4186: WHERE
4187:
4188: prha.requisition_header_id = prla.requisition_header_id