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 2905: FROM po_line_locations_all

2901: v_processed NUMBER; --File.Sql.35 Cbabu := 0;
2902:
2903: CURSOR c_line_location_qty( p_line_location_id IN NUMBER) IS
2904: SELECT quantity
2905: FROM po_line_locations_all
2906: WHERE line_location_id = p_line_location_id;
2907:
2908: CURSOR c_enable_trace IS
2909: SELECT enable_trace

Line 2942: trigger ja_in_po_tax_insert_trg on PO_LINE_LOCATIONS_ALL. The main concepts

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

Line 3180: FROM Po_Line_Locations_all

3176:
3177: ------------------------------ ------------------------------ ------------------------------ ------------------------------
3178:
3179: CURSOR Lines_Cur IS SELECT DISTINCT Po_Line_Id
3180: FROM Po_Line_Locations_all
3181: WHERE Po_Header_Id = v_po_hdr_id;
3182:
3183: CURSOR Fetch_Item_Cur( Lineid IN NUMBER ) IS SELECT Item_Id
3184: FROM Po_Lines_All

Line 3188: FROM po_line_locations_all

3184: FROM Po_Lines_All
3185: WHERE Po_Line_Id = Lineid;
3186:
3187: CURSOR Line_Loc_Cur( lineid IN NUMBER ) IS SELECT Line_Location_Id
3188: FROM po_line_locations_all
3189: WHERE Po_Line_Id = lineid;
3190:
3191: ------------------------------ ------------------------------ ------------------------------ ------------------------------
3192:

Line 3199: FROM Po_Line_Locations_All

3195: WHERE Po_Line_Id = lineid;
3196:
3197: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS SELECT Quantity, Price_Override,
3198: Unit_Meas_Lookup_Code
3199: FROM Po_Line_Locations_All
3200: WHERE Po_Line_Id = lineid
3201: AND Line_Location_Id = linelocid;
3202: -- Get the Uom Code
3203:

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

6545:
6546: CURSOR Fetch_Focus_Id_Cur IS
6547: SELECT JAI_PO_LINE_LOCATIONS_S.nextval FROM Dual;
6548:
6549: -- Cursor definition for picking line_location_id from po_line_locations_all
6550:
6551: CURSOR Fetch_Line_Loc_Id_Cur IS
6552: SELECT jpll.Line_Location_Id
6553: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,

Line 6553: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,

6549: -- Cursor definition for picking line_location_id from po_line_locations_all
6550:
6551: CURSOR Fetch_Line_Loc_Id_Cur IS
6552: SELECT jpll.Line_Location_Id
6553: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
6554: po_lines_all pla, po_headers_all pha
6555: WHERE pha.po_header_id = pla.po_header_id
6556: AND jpll.line_location_id = plla.line_location_id
6557: AND pha.po_header_id = plla.po_header_id

Line 7096: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL

7092: SELECT tax_category_id INTO v_tax_category_id_holder
7093: FROM JAI_PO_LINE_LOCATIONS
7094: WHERE po_line_id = p_frm_line_id
7095: AND (line_location_id IS NULL OR line_location_id = 0);
7096: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
7097: SELECT tax_category_id INTO v_tax_category_id_holder
7098: FROM JAI_PO_LINE_LOCATIONS
7099: WHERE po_line_id = p_frm_line_id
7100: AND line_location_id = v_quot_line_loc_id;

Line 7261: FROM Po_Line_Locations_All

7257:
7258: v_junk_uom MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE; -- Added by Vijay Shankar for Bug# 3205861
7259: CURSOR Fetch_Qty_Cur( llid IN NUMBER ) IS
7260: SELECT Quantity, Price_Override, Unit_Meas_Lookup_Code
7261: FROM Po_Line_Locations_All
7262: WHERE Line_Location_Id = llid;
7263:
7264: -- CURSOR Fetch_Cum_Qty_Cur IS
7265: 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 7265: 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

7261: FROM Po_Line_Locations_All
7262: WHERE Line_Location_Id = llid;
7263:
7264: -- CURSOR Fetch_Cum_Qty_Cur IS
7265: 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
7266: SELECT SUM( Quantity )
7267: FROM Po_Line_Locations_All PLL
7268: WHERE Po_Line_Id = p_line_id
7269: -- cbabu for Bug# 3102375

Line 7267: FROM Po_Line_Locations_All PLL

7263:
7264: -- CURSOR Fetch_Cum_Qty_Cur IS
7265: 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
7266: SELECT SUM( Quantity )
7267: FROM Po_Line_Locations_All PLL
7268: WHERE Po_Line_Id = p_line_id
7269: -- cbabu for Bug# 3102375
7270: AND shipment_type <> cp_shipment_type --'PRICE BREAK'
7271: AND ((pQryOn = 'ALL' AND PLL.SHIP_TO_ORGANIZATION_ID = pShipToOrganizationId AND PLL.SHIP_TO_LOCATION_ID = pShipToLocationId )

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

7273: OR (pQryOn = 'NULL' AND PLL.SHIP_TO_ORGANIZATION_ID IS NULL AND PLL.SHIP_TO_LOCATION_ID IS NULL )
7274: );
7275:
7276: -- CURSOR Fetch_Count_Llid_Cur IS
7277: 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
7278: SELECT NVL( COUNT( Line_Location_Id ), 0 )
7279: FROM Po_Line_Locations_All PLL
7280: WHERE Po_Line_Id = p_line_id
7281: AND Shipment_Type = cp_shipment_type --'PRICE BREAK'

Line 7279: FROM Po_Line_Locations_All PLL

7275:
7276: -- CURSOR Fetch_Count_Llid_Cur IS
7277: 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
7278: SELECT NVL( COUNT( Line_Location_Id ), 0 )
7279: FROM Po_Line_Locations_All PLL
7280: WHERE Po_Line_Id = p_line_id
7281: AND Shipment_Type = cp_shipment_type --'PRICE BREAK'
7282: -- cbabu for Bug# 3102375
7283: AND ((pQryOn = 'ALL' AND PLL.SHIP_TO_ORGANIZATION_ID = pShipToOrganizationId AND PLL.SHIP_TO_LOCATION_ID = pShipToLocationId )

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

7286: )
7287: AND SYSDATE between nvl(start_date, SYSDATE) and nvl(end_date, SYSDATE);
7288:
7289: -- CURSOR Fetch_Locid_Cur IS
7290: CURSOR Fetch_Locid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
7291: SELECT Line_Location_Id, Quantity, Price_Override, Unit_Meas_Lookup_Code
7292: FROM Po_Line_Locations_All PLL
7293: WHERE Po_Header_Id = p_hdr_id
7294: AND Po_Line_Id = p_line_id

Line 7292: FROM Po_Line_Locations_All PLL

7288:
7289: -- CURSOR Fetch_Locid_Cur IS
7290: CURSOR Fetch_Locid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
7291: SELECT Line_Location_Id, Quantity, Price_Override, Unit_Meas_Lookup_Code
7292: FROM Po_Line_Locations_All PLL
7293: WHERE Po_Header_Id = p_hdr_id
7294: AND Po_Line_Id = p_line_id
7295: AND Shipment_Type = cp_shipment_type --'PRICE BREAK'
7296: -- cbabu for Bug# 3102375

Line 7307: FROM po_line_locations_all

7303:
7304: -- added by cbabu for Bug# 3102375
7305: CURSOR cShipmentDetails(pLineLocationId IN NUMBER) IS
7306: SELECT ship_to_organization_id, ship_to_location_id
7307: FROM po_line_locations_all
7308: WHERE line_location_id = pLineLocationId;
7309: vShpDtl cShipmentDetails%ROWTYPE;
7310:
7311: ------------------------------Added by Nagaraj.s for Bug2461414>

Line 7314: FROM Po_Line_Locations_All

7310:
7311: ------------------------------Added by Nagaraj.s for Bug2461414>
7312: CURSOR Fetch_Price_cur IS
7313: SELECT Price_Override
7314: FROM Po_Line_Locations_All
7315: WHERE po_header_id = p_hdr_id
7316: AND po_line_id = p_line_id
7317: AND line_location_id=p_line_loc_id;
7318:

Line 7398: FROM Po_Line_Locations_All

7394: where po_header_id=p_po_hdr_id;
7395:
7396: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS
7397: SELECT Price_Override ,Unit_Meas_Lookup_Code
7398: FROM Po_Line_Locations_All
7399: WHERE Po_Line_Id = lineid
7400: AND Line_Location_Id = linelocid;
7401:
7402: CURSOR Fetch_Org_Id_Cur IS

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

7414: CHANGE HISTORY: FILENAME: ja_in_po_conc_process_p.sql
7415: S.No Date Author and Details
7416: -------------------------------------------------------------------------------------------------------------------------
7417: 1 01/08/2002 Nagaraj.s for Bug#2461414
7418: The Unit Price in case of an Blanket release was being fetched from po_line_locations_all where
7419: shipment type ='PRICE BREAK' The Price is now calculated based upon the price as available in base
7420: apps screen based upon which taxes are calculated properly.
7421:
7422: 2 06/12/2002 cbabu for EnhancementBug# 2427465, FileVersion# 615.2

Line 7929: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL

7925: SELECT tax_category_id INTO v_tax_category_id_holder
7926: FROM JAI_PO_LINE_LOCATIONS
7927: WHERE po_line_id = v_po_line_id
7928: AND (line_location_id IS NULL OR line_location_id = 0);
7929: ELSE -- line_location_id is present in PO_LINE_LOCATIONS_ALL
7930: SELECT tax_category_id INTO v_tax_category_id_holder
7931: FROM JAI_PO_LINE_LOCATIONS
7932: WHERE po_line_id = v_po_line_id
7933: AND line_location_id = v_line_loc_id;

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

8110: v_last_upd_by IN NUMBER,
8111: v_last_upd_login IN NUMBER,
8112: flag IN VARCHAR2,
8113: success IN OUT NOCOPY NUMBER, -- If success doesnt return 0, then Use Ja_In_Po_Case2
8114: p_quantity IN PO_LINE_LOCATIONS_ALL.quantity%TYPE DEFAULT NULL --added by csahoo for bug#6144740
8115: )
8116: IS
8117:
8118: v_seq_val NUMBER;

Line 8237: FROM po_line_locations_all

8233: --Start,Added the following for forward porting to R12 kundan kumar
8234:
8235: CURSOR c_po_quantity_1(p_po_line_id IN NUMBER) IS
8236: SELECT quantity
8237: FROM po_line_locations_all
8238: WHERE po_line_id = p_po_line_id
8239: AND line_location_id IS NULL ;
8240:
8241: CURSOR c_po_quantity_2(p_po_line_id IN NUMBER,p_po_line_location_id NUMBER ) IS

Line 8243: FROM po_line_locations_all

8239: AND line_location_id IS NULL ;
8240:
8241: CURSOR c_po_quantity_2(p_po_line_id IN NUMBER,p_po_line_location_id NUMBER ) IS
8242: SELECT quantity
8243: FROM po_line_locations_all
8244: WHERE po_line_id = p_po_line_id
8245: AND line_location_id = p_po_line_location_id ;
8246:
8247: lv_adhoc_flag VARCHAR2(1) ;