APPS.CTO_AUTO_PROCURE_PK dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 171: | po_requisitions_interface_all table

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

Line 525: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria

521: cursor eligible_lines_cur is
522: select bcolt.line_id line_id,
523: bcolt.org_id org_id,
524: Nvl(Sum(quantity),0) qty
525: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria
526: where bcolt.status = 1
527: and pria.interface_source_line_id(+) = bcolt.line_id
528: and pria.process_flag is null
529: group by bcolt.org_id, bcolt.line_id

Line 1236: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria

1232: err_line_id number;
1233:
1234: cursor error_lines_cur is
1235: select bcolt.line_id
1236: from bom_cto_order_lines_temp bcolt, po_requisitions_interface_all pria
1237: where bcolt.status = 1
1238: and pria.interface_source_line_id(+) = bcolt.line_id
1239: and pria.process_flag = 'ERROR';
1240: begin

Line 2053: INSERT INTO po_requisitions_interface_all (

2049:
2050: --bugfix 4545559 changed the insert from
2051: --po_requisitions_interface to _all table
2052: l_stmt_num := 210;
2053: INSERT INTO po_requisitions_interface_all (
2054: interface_source_code,
2055: destination_organization_id,
2056: deliver_to_location_id,
2057: deliver_to_requestor_id,

Line 2220: -- we need add another where condition for item_id in po_requisitions_interface_all table

2216: get the the quantity to be reserved for the demand.
2217: *****************************************************************************/
2218: -- Fix for performance bug 4897231
2219: -- To avoid full table scan on po_requisitions_table
2220: -- we need add another where condition for item_id in po_requisitions_interface_all table
2221: -- As most of the calling modules for this API already has item_id,
2222: -- we add a new parameter p_item_id for this procedure
2223: -- This parameter will be used in the where clause of po_requisition_intface table
2224:

Line 2245: FROM po_requisitions_interface_all

2241: -- Po_req_interface table has index on item_id column
2242:
2243: CURSOR c1(p_line_id NUMBER,p_inv_item_id number) IS
2244: SELECT Nvl(Sum(quantity),0) qty
2245: FROM po_requisitions_interface_all
2246: WHERE interface_source_line_id = p_line_id
2247: and item_id = p_inv_item_id
2248: AND process_flag is null;
2249:

Line 2255: l_quantity_interface po_requisitions_interface_all.quantity%TYPE;

2251: SELECT nvl(SUM(reservation_quantity), 0) qty
2252: FROM mtl_reservations
2253: WHERE demand_source_line_id = p_interface_source_line_id;
2254:
2255: l_quantity_interface po_requisitions_interface_all.quantity%TYPE;
2256: l_open_flow_qty Number := 0;
2257:
2258: --Bugfix 13500057
2259: l_oel_shipped_qty number;

Line 2444: from po_requisitions_interface_all

2440:
2441: BEGIN
2442: select 'EXTERNAL_REQ_REQUESTED'
2443: into p_flow_status
2444: from po_requisitions_interface_all
2445: where interface_source_line_id = so_line.line_id
2446: and item_id = so_line.inventory_item_id
2447: and process_flag is null
2448: and rownum =1;