DBA Data[Home] [Help]

APPS.AP_FUNDS_CONTROL_PKG dependencies on PO_UOM_S

Line 1673: po_uom_s.po_uom_convert(

1669: --new_qty_variance
1670: (((sum(decode(d.match_status_flag,
1671: 'A',nvl(decode(p_match_option,
1672: 'R', (d.quantity_invoiced *
1673: po_uom_s.po_uom_convert(
1674: nvl(d.matched_uom_lookup_code,
1675: p_po_uom), p_po_uom
1676: ,p_item_id)),
1677: d.quantity_invoiced), 0),

Line 1682: po_uom_s.po_uom_convert(

1678: decode(d.invoice_id, p_invoice_id,
1679: nvl(decode(p_match_option,
1680: 'R',
1681: (d.quantity_invoiced *
1682: po_uom_s.po_uom_convert(
1683: nvl(d.matched_uom_lookup_code, p_po_uom), p_po_uom, p_item_id)),
1684: d.quantity_invoiced), 0),
1685: decode(d.match_status_flag, 'A', 0,
1686: nvl(decode(p_match_option,

Line 1689: po_uom_s.po_uom_convert(

1685: decode(d.match_status_flag, 'A', 0,
1686: nvl(decode(p_match_option,
1687: 'R',
1688: (d.quantity_invoiced *
1689: po_uom_s.po_uom_convert(
1690: nvl(d.matched_uom_lookup_code, p_po_uom), p_po_uom, p_item_id)),
1691: d.quantity_invoiced), 0)))
1692: )) - p_po_qty ) * p_po_price)
1693: - sum(nvl(d.quantity_variance,0))),

Line 1701: po_uom_s.po_uom_convert(

1697: nvl(PD.rate,1)) *
1698: (((sum(decode(d.match_status_flag,
1699: 'A',nvl(decode(p_match_option,
1700: 'R',(d.quantity_invoiced *
1701: po_uom_s.po_uom_convert(
1702: nvl(d.matched_uom_lookup_code
1703: ,p_po_uom), p_po_uom
1704: ,p_item_id)),
1705: d.quantity_invoiced),

Line 1711: po_uom_s.po_uom_convert(

1707: decode(d.invoice_id, p_invoice_id,
1708: nvl(decode(p_match_option,
1709: 'R',
1710: (d.quantity_invoiced *
1711: po_uom_s.po_uom_convert(
1712: nvl(d.matched_uom_lookup_code, p_po_uom), p_po_uom, p_item_id)),
1713: d.quantity_invoiced), 0),
1714: decode(d.match_status_flag, 'A', 0,
1715: nvl(decode(p_match_option,

Line 1718: po_uom_s.po_uom_convert(

1714: decode(d.match_status_flag, 'A', 0,
1715: nvl(decode(p_match_option,
1716: 'R',
1717: (d.quantity_invoiced *
1718: po_uom_s.po_uom_convert(
1719: nvl(d.matched_uom_lookup_code, p_po_uom), p_po_uom, p_item_id)),
1720: d.quantity_invoiced), 0)))
1721: )) - p_po_qty ) * p_po_price)
1722: - sum(nvl(d.quantity_variance,0))),

Line 1728: po_uom_s.po_uom_convert(

1724: sum(decode(d.invoice_id, p_invoice_id,
1725: decode(match_status_flag,
1726: 'A',0,
1727: nvl(decode(p_match_option, 'R', (quantity_invoiced *
1728: po_uom_s.po_uom_convert(
1729: nvl(d.matched_uom_lookup_code,
1730: p_po_uom), p_po_uom, p_item_id))
1731: ,quantity_invoiced),0)),
1732: 0)),

Line 1739: po_uom_s.po_uom_convert(

1735: decode(match_status_flag,
1736: 'A',0,
1737: nvl(decode(p_match_option,'R',
1738: (quantity_invoiced *
1739: po_uom_s.po_uom_convert(
1740: nvl(d.matched_uom_lookup_code,
1741: p_po_uom), p_po_uom
1742: , p_item_id))
1743: ,quantity_invoiced),0)),