DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 7359: from po_requisitions_interface_all po,

7355: Select sum(CTO_UTILITY_PK.convert_uom(po.uom_code,x_primary_uom_code,nvl(po.quantity,0),po.item_id)),
7356: sum(nvl(po.secondary_quantity,0))
7357: into l_ext_req_qty,
7358: l_ext_req_secondary_qty
7359: from po_requisitions_interface_all po,
7360: oe_order_lines_all oel
7361: where po.interface_source_line_id = oel.line_id
7362: and oel.line_id = p_order_line_id
7363: and po.item_id = oel.inventory_item_id

Line 7371: from po_requisitions_interface_all po,

7367: Select sum(CTO_UTILITY_PK.convert_uom(po.uom_code,x_primary_uom_code,nvl(po.quantity,0),po.item_id)),
7368: sum(nvl(po.secondary_quantity,0))
7369: into l_int_req_qty,
7370: l_int_req_secondary_qty --changed as part of opm code review
7371: from po_requisitions_interface_all po,
7372: oe_order_lines_all oel
7373: where po.interface_source_line_id = oel.line_id
7374: and oel.line_id = p_order_line_id
7375: and po.item_id = oel.inventory_item_id