[Home] [Help]
167: |
168: |Aug 29th,2005 Kiran Konada
169: | bugfix 4545559
170: | changed the insert from po_requisitions_interface to
171: | po_requisitions_interface_all table
172: |
173: |
174: |Sep 22nd,2005 Kiran Konada
175: | Created new local procedure Get_opm_charge_account
1726:
1727: --bugfix 4545559 changed the insert from
1728: --po_requisitions_interface to _all table
1729: l_stmt_num := 210;
1730: INSERT INTO po_requisitions_interface_all (
1731: interface_source_code,
1732: destination_organization_id,
1733: deliver_to_location_id,
1734: deliver_to_requestor_id,
1890: get the the quantity to be reserved for the demand.
1891: *****************************************************************************/
1892: -- Fix for performance bug 4897231
1893: -- To avoid full table scan on po_requisitions_table
1894: -- we need add another where condition for item_id in po_requisitions_interface_all table
1895: -- As most of the calling modules for this API already has item_id,
1896: -- we add a new parameter p_item_id for this procedure
1897: -- This parameter will be used in the where clause of po_requisition_intface table
1898:
1914: -- Po_req_interface table has index on item_id column
1915:
1916: CURSOR c1(p_line_id NUMBER,p_inv_item_id number) IS
1917: SELECT Nvl(Sum(quantity),0) qty
1918: FROM po_requisitions_interface_all
1919: WHERE interface_source_line_id = p_line_id
1920: and item_id = p_inv_item_id
1921: AND process_flag is null;
1922:
1924: SELECT nvl(SUM(reservation_quantity), 0) qty
1925: FROM mtl_reservations
1926: WHERE demand_source_line_id = p_interface_source_line_id;
1927:
1928: l_quantity_interface po_requisitions_interface_all.quantity%TYPE;
1929: l_open_flow_qty Number := 0;
1930:
1931: BEGIN
1932:
2055:
2056: BEGIN
2057: select 'EXTERNAL_REQ_REQUESTED'
2058: into p_flow_status
2059: from po_requisitions_interface_all
2060: where interface_source_line_id = so_line.line_id
2061: and item_id = so_line.inventory_item_id
2062: and process_flag is null
2063: and rownum =1;