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_PO_TAX_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 2184: FROM po_line_locations_all

2180: v_processed NUMBER; --File.Sql.35 Cbabu := 0;
2181:
2182: CURSOR c_line_location_qty( p_line_location_id IN NUMBER) IS
2183: SELECT quantity
2184: FROM po_line_locations_all
2185: WHERE line_location_id = p_line_location_id;
2186:
2187: CURSOR c_enable_trace IS
2188: SELECT enable_trace

Line 2221: trigger ja_in_po_tax_insert_trg on PO_LINE_LOCATIONS_ALL. The main concepts

2217: This trigger was created to move the processing of shipment lines while PO gets generated
2218: ja_in_bulk_po_quot_taxes_pfrom Quotation (used from MRP also). the concurrent was getting submitted for every shipment
2219: ja_in_bulk_po_quot_taxes_pline of the PO, to default the tax lines. With this procedure all such shipment lines
2220: will be processed as 1 concurrent. The temporary table used here is being populated from the
2221: trigger ja_in_po_tax_insert_trg on PO_LINE_LOCATIONS_ALL. The main concepts
2222: used here are,
2223: - if an error occurs while processing a particular record, the program will skip processing
2224: all other shipment lines of the error PO(Purchase Order).
2225: - the program will continue to process other PO's.

Line 2456: FROM Po_Line_Locations_all

2452:
2453: ------------------------------ ------------------------------ ------------------------------ ------------------------------
2454:
2455: CURSOR Lines_Cur IS SELECT DISTINCT Po_Line_Id
2456: FROM Po_Line_Locations_all
2457: WHERE Po_Header_Id = v_po_hdr_id;
2458:
2459: CURSOR Fetch_Item_Cur( Lineid IN NUMBER ) IS SELECT Item_Id
2460: FROM Po_Lines_All

Line 2464: FROM po_line_locations_all

2460: FROM Po_Lines_All
2461: WHERE Po_Line_Id = Lineid;
2462:
2463: CURSOR Line_Loc_Cur( lineid IN NUMBER ) IS SELECT Line_Location_Id
2464: FROM po_line_locations_all
2465: WHERE Po_Line_Id = lineid;
2466:
2467: ------------------------------ ------------------------------ ------------------------------ ------------------------------
2468:

Line 2475: FROM Po_Line_Locations_All

2471: WHERE Po_Line_Id = lineid;
2472:
2473: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS SELECT Quantity, Price_Override,
2474: Unit_Meas_Lookup_Code
2475: FROM Po_Line_Locations_All
2476: WHERE Po_Line_Id = lineid
2477: AND Line_Location_Id = linelocid;
2478: -- Get the Uom Code
2479:

Line 5160: -- Cursor definition for picking line_location_id from po_line_locations_all

5156:
5157: CURSOR Fetch_Focus_Id_Cur IS
5158: SELECT JAI_PO_LINE_LOCATIONS_S.nextval FROM Dual;
5159:
5160: -- Cursor definition for picking line_location_id from po_line_locations_all
5161:
5162: CURSOR Fetch_Line_Loc_Id_Cur IS
5163: SELECT jpll.Line_Location_Id
5164: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,

Line 5164: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,

5160: -- Cursor definition for picking line_location_id from po_line_locations_all
5161:
5162: CURSOR Fetch_Line_Loc_Id_Cur IS
5163: SELECT jpll.Line_Location_Id
5164: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
5165: po_lines_all pla, po_headers_all pha
5166: WHERE pha.po_header_id = pla.po_header_id
5167: AND jpll.line_location_id = plla.line_location_id
5168: AND pha.po_header_id = plla.po_header_id

Line 5702: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL

5698: SELECT tax_category_id INTO v_tax_category_id_holder
5699: FROM JAI_PO_LINE_LOCATIONS
5700: WHERE po_line_id = p_frm_line_id
5701: AND (line_location_id IS NULL OR line_location_id = 0);
5702: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
5703: SELECT tax_category_id INTO v_tax_category_id_holder
5704: FROM JAI_PO_LINE_LOCATIONS
5705: WHERE po_line_id = p_frm_line_id
5706: AND line_location_id = v_quot_line_loc_id;

Line 5845: FROM Po_Line_Locations_All

5841:
5842: v_junk_uom MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE; -- Added by Vijay Shankar for Bug# 3205861
5843: CURSOR Fetch_Qty_Cur( llid IN NUMBER ) IS
5844: SELECT Quantity, Price_Override, Unit_Meas_Lookup_Code
5845: FROM Po_Line_Locations_All
5846: WHERE Line_Location_Id = llid;
5847:
5848: -- CURSOR Fetch_Cum_Qty_Cur IS
5849: CURSOR Fetch_Cum_Qty_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS

Line 5849: CURSOR Fetch_Cum_Qty_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS

5845: FROM Po_Line_Locations_All
5846: WHERE Line_Location_Id = llid;
5847:
5848: -- CURSOR Fetch_Cum_Qty_Cur IS
5849: CURSOR Fetch_Cum_Qty_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5850: SELECT SUM( Quantity )
5851: FROM Po_Line_Locations_All PLL
5852: WHERE Po_Line_Id = p_line_id
5853: -- cbabu for Bug# 3102375

Line 5851: FROM Po_Line_Locations_All PLL

5847:
5848: -- CURSOR Fetch_Cum_Qty_Cur IS
5849: CURSOR Fetch_Cum_Qty_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5850: SELECT SUM( Quantity )
5851: FROM Po_Line_Locations_All PLL
5852: WHERE Po_Line_Id = p_line_id
5853: -- cbabu for Bug# 3102375
5854: AND shipment_type <> cp_shipment_type --'PRICE BREAK'
5855: AND ((pQryOn = 'ALL' AND PLL.SHIP_TO_ORGANIZATION_ID = pShipToOrganizationId AND PLL.SHIP_TO_LOCATION_ID = pShipToLocationId )

Line 5861: CURSOR Fetch_Count_Llid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS

5857: OR (pQryOn = 'NULL' AND PLL.SHIP_TO_ORGANIZATION_ID IS NULL AND PLL.SHIP_TO_LOCATION_ID IS NULL )
5858: );
5859:
5860: -- CURSOR Fetch_Count_Llid_Cur IS
5861: CURSOR Fetch_Count_Llid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5862: SELECT NVL( COUNT( Line_Location_Id ), 0 )
5863: FROM Po_Line_Locations_All PLL
5864: WHERE Po_Line_Id = p_line_id
5865: AND Shipment_Type = cp_shipment_type --'PRICE BREAK'

Line 5863: FROM Po_Line_Locations_All PLL

5859:
5860: -- CURSOR Fetch_Count_Llid_Cur IS
5861: CURSOR Fetch_Count_Llid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5862: SELECT NVL( COUNT( Line_Location_Id ), 0 )
5863: FROM Po_Line_Locations_All PLL
5864: WHERE Po_Line_Id = p_line_id
5865: AND Shipment_Type = cp_shipment_type --'PRICE BREAK'
5866: -- cbabu for Bug# 3102375
5867: AND ((pQryOn = 'ALL' AND PLL.SHIP_TO_ORGANIZATION_ID = pShipToOrganizationId AND PLL.SHIP_TO_LOCATION_ID = pShipToLocationId )

Line 5874: CURSOR Fetch_Locid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS

5870: )
5871: AND SYSDATE between nvl(start_date, SYSDATE) and nvl(end_date, SYSDATE);
5872:
5873: -- CURSOR Fetch_Locid_Cur IS
5874: CURSOR Fetch_Locid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5875: SELECT Line_Location_Id, Quantity, Price_Override, Unit_Meas_Lookup_Code
5876: FROM Po_Line_Locations_All PLL
5877: WHERE Po_Header_Id = p_hdr_id
5878: AND Po_Line_Id = p_line_id

Line 5876: FROM Po_Line_Locations_All PLL

5872:
5873: -- CURSOR Fetch_Locid_Cur IS
5874: CURSOR Fetch_Locid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5875: SELECT Line_Location_Id, Quantity, Price_Override, Unit_Meas_Lookup_Code
5876: FROM Po_Line_Locations_All PLL
5877: WHERE Po_Header_Id = p_hdr_id
5878: AND Po_Line_Id = p_line_id
5879: AND Shipment_Type = cp_shipment_type --'PRICE BREAK'
5880: -- cbabu for Bug# 3102375

Line 5891: FROM po_line_locations_all

5887:
5888: -- added by cbabu for Bug# 3102375
5889: CURSOR cShipmentDetails(pLineLocationId IN NUMBER) IS
5890: SELECT ship_to_organization_id, ship_to_location_id
5891: FROM po_line_locations_all
5892: WHERE line_location_id = pLineLocationId;
5893: vShpDtl cShipmentDetails%ROWTYPE;
5894:
5895: ------------------------------Added by Nagaraj.s for Bug2461414>

Line 5898: FROM Po_Line_Locations_All

5894:
5895: ------------------------------Added by Nagaraj.s for Bug2461414>
5896: CURSOR Fetch_Price_cur IS
5897: SELECT Price_Override
5898: FROM Po_Line_Locations_All
5899: WHERE po_header_id = p_hdr_id
5900: AND po_line_id = p_line_id
5901: AND line_location_id=p_line_loc_id;
5902:

Line 5982: FROM Po_Line_Locations_All

5978: where po_header_id=p_po_hdr_id;
5979:
5980: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS
5981: SELECT Price_Override ,Unit_Meas_Lookup_Code
5982: FROM Po_Line_Locations_All
5983: WHERE Po_Line_Id = lineid
5984: AND Line_Location_Id = linelocid;
5985:
5986: CURSOR Fetch_Org_Id_Cur IS

Line 6002: The Unit Price in case of an Blanket release was being fetched from po_line_locations_all where

5998: CHANGE HISTORY: FILENAME: ja_in_po_conc_process_p.sql
5999: S.No Date Author and Details
6000: -------------------------------------------------------------------------------------------------------------------------
6001: 1 01/08/2002 Nagaraj.s for Bug#2461414
6002: The Unit Price in case of an Blanket release was being fetched from po_line_locations_all where
6003: shipment type ='PRICE BREAK' The Price is now calculated based upon the price as available in base
6004: apps screen based upon which taxes are calculated properly.
6005:
6006: 2 06/12/2002 cbabu for EnhancementBug# 2427465, FileVersion# 615.2

Line 6482: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL

6478: SELECT tax_category_id INTO v_tax_category_id_holder
6479: FROM JAI_PO_LINE_LOCATIONS
6480: WHERE po_line_id = v_po_line_id
6481: AND (line_location_id IS NULL OR line_location_id = 0);
6482: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
6483: SELECT tax_category_id INTO v_tax_category_id_holder
6484: FROM JAI_PO_LINE_LOCATIONS
6485: WHERE po_line_id = v_po_line_id
6486: AND line_location_id = v_line_loc_id;

Line 6634: p_quantity IN PO_LINE_LOCATIONS_ALL.quantity%TYPE DEFAULT NULL --added by csahoo for bug#6144740

6630: v_last_upd_by IN NUMBER,
6631: v_last_upd_login IN NUMBER,
6632: flag IN VARCHAR2,
6633: success IN OUT NOCOPY NUMBER, -- If success doesnt return 0, then Use Ja_In_Po_Case2
6634: p_quantity IN PO_LINE_LOCATIONS_ALL.quantity%TYPE DEFAULT NULL --added by csahoo for bug#6144740
6635: )
6636: IS
6637:
6638: v_seq_val NUMBER;

Line 6754: FROM po_line_locations_all

6750: --Start,Added the following for forward porting to R12 kundan kumar
6751:
6752: CURSOR c_po_quantity_1(p_po_line_id IN NUMBER) IS
6753: SELECT quantity
6754: FROM po_line_locations_all
6755: WHERE po_line_id = p_po_line_id
6756: AND line_location_id IS NULL ;
6757:
6758: CURSOR c_po_quantity_2(p_po_line_id IN NUMBER,p_po_line_location_id NUMBER ) IS

Line 6760: FROM po_line_locations_all

6756: AND line_location_id IS NULL ;
6757:
6758: CURSOR c_po_quantity_2(p_po_line_id IN NUMBER,p_po_line_location_id NUMBER ) IS
6759: SELECT quantity
6760: FROM po_line_locations_all
6761: WHERE po_line_id = p_po_line_id
6762: AND line_location_id = p_po_line_location_id ;
6763:
6764: lv_adhoc_flag VARCHAR2(1) ;