DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 7477: from po_requisitions_interface_all po,

7473: Select sum(CTO_UTILITY_PK.convert_uom(po.uom_code,x_primary_uom_code,nvl(po.quantity,0),po.item_id)),
7474: sum(nvl(po.secondary_quantity,0))
7475: into l_ext_req_qty,
7476: l_ext_req_secondary_qty
7477: from po_requisitions_interface_all po,
7478: oe_order_lines_all oel
7479: where po.interface_source_line_id = oel.line_id
7480: and oel.line_id = p_order_line_id
7481: and po.item_id = oel.inventory_item_id

Line 7490: from po_requisitions_interface_all po,

7486: Select sum(CTO_UTILITY_PK.convert_uom(po.uom_code,x_primary_uom_code,nvl(po.quantity,0),po.item_id)),
7487: sum(nvl(po.secondary_quantity,0))
7488: into l_int_req_qty,
7489: l_int_req_secondary_qty --changed as part of opm code review
7490: from po_requisitions_interface_all po,
7491: oe_order_lines_all oel
7492: where po.interface_source_line_id = oel.line_id
7493: and oel.line_id = p_order_line_id
7494: and po.item_id = oel.inventory_item_id