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 610: FROM po_headers_all

606: PROCEDURE pick_po_header_date IS
607: BEGIN
608: FOR date_rec IN (SELECT creation_date,
609: vendor_site_id
610: FROM po_headers_all
611: WHERE po_header_id = p_po_header_id)
612: LOOP
613: v_po_header_date := date_rec.creation_date;
614: v_vendor_site_id := date_rec.vendor_site_id;

Line 1601: FROM po_headers_all

1597: ELSIF p_transaction_type = 'MATCH' THEN
1598:
1599: FOR po_rec IN (SELECT currency_code,
1600: rate
1601: FROM po_headers_all
1602: WHERE po_header_id = p_po_header_id)
1603: LOOP
1604: v_currency_code := po_rec.currency_code;
1605: v_currency_conversion_rate := po_rec.rate;

Line 1787: from po_headers_all pha

1783: FROM rcv_shipment_lines rsl
1784: Where rsl.to_organization_id = p_organization_id
1785: and exists -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. rsl.po_header_id in
1786: (select pha.po_header_id
1787: from po_headers_all pha
1788: Where pha.vendor_site_id=p_vendor_site_id
1789: and po_header_id = rsl.po_header_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.
1790: )
1791: and rsl.shipment_line_id in

Line 2271: FROM po_headers_all

2267: SELECT currency_code,
2268: rate
2269: INTO v_po_currency,
2270: v_po_rate
2271: FROM po_headers_all
2272: WHERE po_header_id = p_po_header_id;
2273: EXCEPTION
2274: WHEN OTHERS THEN
2275: IF v_debug_flag = 'Y' THEN