DBA Data[Home] [Help]

APPS.JAI_RCV_TAX_PKG dependencies on PO_HEADERS_ALL

Line 69: v_vendor_site_id po_headers_all.vendor_site_id % TYPE;

65: v_receipt_modify_flag JAI_CMN_INVENTORY_ORGS.receipt_modify_flag % TYPE;
66: v_cor_quantity NUMBER;
67: v_rg_location_id JAI_INV_SUBINV_DTLS.location_id % TYPE;
68: v_po_header_date DATE;
69: v_vendor_site_id po_headers_all.vendor_site_id % 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;

Line 118: v_po_currency po_headers_all.CURRENCY_CODE%TYPE;

114: v_chk_receipt_lines NUMBER; --File.Sql.35 Cbabu :=0;
115: v_chk_receipt_tax_lines NUMBER; --File.Sql.35 Cbabu :=0;
116: --v_receipt_routing NUMBER; --Added by Nagaraj.s for Bug#2499017
117: -- Variables added by Aparajita on 17th june for bug#2415767
118: v_po_currency po_headers_all.CURRENCY_CODE%TYPE;
119: v_po_rate po_headers_all.RATE%TYPE;
120: v_tax_currency po_headers_all.CURRENCY_CODE%TYPE;
121:
122: v_precedence_0 NUMBER; --File.Sql.35 Cbabu :=0;

Line 119: v_po_rate po_headers_all.RATE%TYPE;

115: v_chk_receipt_tax_lines NUMBER; --File.Sql.35 Cbabu :=0;
116: --v_receipt_routing NUMBER; --Added by Nagaraj.s for Bug#2499017
117: -- Variables added by Aparajita on 17th june for bug#2415767
118: v_po_currency po_headers_all.CURRENCY_CODE%TYPE;
119: v_po_rate po_headers_all.RATE%TYPE;
120: v_tax_currency po_headers_all.CURRENCY_CODE%TYPE;
121:
122: v_precedence_0 NUMBER; --File.Sql.35 Cbabu :=0;
123: v_precedence_non_0 NUMBER; --File.Sql.35 Cbabu :=0;

Line 120: v_tax_currency po_headers_all.CURRENCY_CODE%TYPE;

116: --v_receipt_routing NUMBER; --Added by Nagaraj.s for Bug#2499017
117: -- Variables added by Aparajita on 17th june for bug#2415767
118: v_po_currency po_headers_all.CURRENCY_CODE%TYPE;
119: v_po_rate po_headers_all.RATE%TYPE;
120: v_tax_currency po_headers_all.CURRENCY_CODE%TYPE;
121:
122: v_precedence_0 NUMBER; --File.Sql.35 Cbabu :=0;
123: v_precedence_non_0 NUMBER; --File.Sql.35 Cbabu :=0;
124:

Line 533: FROM po_headers_all

529: PROCEDURE pick_po_header_date IS
530: BEGIN
531: FOR date_rec IN (SELECT creation_date,
532: vendor_site_id
533: FROM po_headers_all
534: WHERE po_header_id = p_po_header_id)
535: LOOP
536: v_po_header_date := date_rec.creation_date;
537: v_vendor_site_id := date_rec.vendor_site_id;

Line 1395: FROM po_headers_all

1391: ELSIF p_transaction_type = 'MATCH' THEN
1392:
1393: FOR po_rec IN (SELECT currency_code,
1394: rate
1395: FROM po_headers_all
1396: WHERE po_header_id = p_po_header_id)
1397: LOOP
1398: v_currency_code := po_rec.currency_code;
1399: v_currency_conversion_rate := po_rec.rate;

Line 1571: from po_headers_all pha

1567: FROM rcv_shipment_lines rsl
1568: Where rsl.to_organization_id = p_organization_id
1569: and exists -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. rsl.po_header_id in
1570: (select pha.po_header_id
1571: from po_headers_all pha
1572: Where pha.vendor_site_id=p_vendor_site_id
1573: and po_header_id = rsl.po_header_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1574: )
1575: and rsl.shipment_line_id in

Line 2025: FROM po_headers_all

2021: SELECT currency_code,
2022: rate
2023: INTO v_po_currency,
2024: v_po_rate
2025: FROM po_headers_all
2026: WHERE po_header_id = p_po_header_id;
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: IF v_debug_flag = 'Y' THEN