DBA Data[Home] [Help]

APPS.AP_FUNDS_CONTROL_PKG dependencies on PO_UOM_S

Line 2049: po_uom_s.po_uom_convert(

2045: --new_qty_variance
2046: (((sum(decode(d.match_status_flag,
2047: 'A',nvl(decode(p_match_option,
2048: 'R', (qty.quantity_invoiced *
2049: po_uom_s.po_uom_convert(
2050: nvl(d.matched_uom_lookup_code,
2051: p_po_uom), p_po_uom
2052: ,p_item_id)),
2053: qty.quantity_invoiced), 0),

Line 2058: po_uom_s.po_uom_convert(

2054: decode(d.invoice_id, p_invoice_id,
2055: nvl(decode(p_match_option,
2056: 'R',
2057: (qty.quantity_invoiced *
2058: po_uom_s.po_uom_convert(
2059: nvl(d.matched_uom_lookup_code, p_po_uom), p_po_uom, p_item_id)),
2060: qty.quantity_invoiced), 0),
2061: decode(d.match_status_flag, 'A', 0,
2062: nvl(decode(p_match_option,

Line 2065: po_uom_s.po_uom_convert(

2061: decode(d.match_status_flag, 'A', 0,
2062: nvl(decode(p_match_option,
2063: 'R',
2064: (qty.quantity_invoiced *
2065: po_uom_s.po_uom_convert(
2066: nvl(d.matched_uom_lookup_code, p_po_uom), p_po_uom, p_item_id)),
2067: qty.quantity_invoiced), 0)))
2068: )) - p_po_qty ) * p_po_price)
2069: - sum(nvl(d.quantity_variance,0))),

Line 2077: po_uom_s.po_uom_convert(

2073: nvl(PD.rate,1)) *
2074: (((sum(decode(d.match_status_flag,
2075: 'A',nvl(decode(p_match_option,
2076: 'R',(qty.quantity_invoiced *
2077: po_uom_s.po_uom_convert(
2078: nvl(d.matched_uom_lookup_code
2079: ,p_po_uom), p_po_uom
2080: ,p_item_id)),
2081: qty.quantity_invoiced),

Line 2087: po_uom_s.po_uom_convert(

2083: decode(d.invoice_id, p_invoice_id,
2084: nvl(decode(p_match_option,
2085: 'R',
2086: (qty.quantity_invoiced *
2087: po_uom_s.po_uom_convert(
2088: nvl(d.matched_uom_lookup_code, p_po_uom), p_po_uom, p_item_id)),
2089: qty.quantity_invoiced), 0),
2090: decode(d.match_status_flag, 'A', 0,
2091: nvl(decode(p_match_option,

Line 2094: po_uom_s.po_uom_convert(

2090: decode(d.match_status_flag, 'A', 0,
2091: nvl(decode(p_match_option,
2092: 'R',
2093: (qty.quantity_invoiced *
2094: po_uom_s.po_uom_convert(
2095: nvl(d.matched_uom_lookup_code, p_po_uom), p_po_uom, p_item_id)),
2096: qty.quantity_invoiced), 0)))
2097: )) - p_po_qty ) * p_po_price)
2098: - sum(nvl(d.quantity_variance,0))),

Line 2104: po_uom_s.po_uom_convert(

2100: sum(decode(d.invoice_id, p_invoice_id,
2101: decode(match_status_flag,
2102: 'A',0,
2103: nvl(decode(p_match_option, 'R', (qty.quantity_invoiced *
2104: po_uom_s.po_uom_convert(
2105: nvl(d.matched_uom_lookup_code,
2106: p_po_uom), p_po_uom, p_item_id))
2107: ,qty.quantity_invoiced),0)),
2108: 0)),

Line 2115: po_uom_s.po_uom_convert(

2111: decode(match_status_flag,
2112: 'A',0,
2113: nvl(decode(p_match_option,'R',
2114: (qty.quantity_invoiced *
2115: po_uom_s.po_uom_convert(
2116: nvl(d.matched_uom_lookup_code,
2117: p_po_uom), p_po_uom
2118: , p_item_id))
2119: ,qty.quantity_invoiced),0)),