eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POA_DBI_PO_DIST_F_C dependencies on POA_DBI_UOM_PKG

Line 723: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))

719: ponip.item_id,
720: null,
721: decode(pll.value_basis,'AMOUNT',1,
722: decode(uom.unit_of_measure,nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code), 1,
723: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
724: ,
725: decode(uom.unit_of_measure,
726: pitem.primary_unit_of_measure, 1,
727: poa_dbi_uom_pkg.convert_to_item_base_uom(

Line 727: poa_dbi_uom_pkg.convert_to_item_base_uom(

723: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
724: ,
725: decode(uom.unit_of_measure,
726: pitem.primary_unit_of_measure, 1,
727: poa_dbi_uom_pkg.convert_to_item_base_uom(
728: ponip.item_id,
729: ppar.master_organization_id,
730: uom.unit_of_measure,
731: pitem.primary_uom_code

Line 798: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))

794: ponip.item_id,
795: null,
796: decode(pll.value_basis,'AMOUNT',1,
797: decode(uom.unit_of_measure,nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code), 1,
798: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
799: ,
800: decode(uom.unit_of_measure,
801: pitem.primary_unit_of_measure, 1,
802: poa_dbi_uom_pkg.convert_to_item_base_uom(

Line 802: poa_dbi_uom_pkg.convert_to_item_base_uom(

798: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
799: ,
800: decode(uom.unit_of_measure,
801: pitem.primary_unit_of_measure, 1,
802: poa_dbi_uom_pkg.convert_to_item_base_uom(
803: ponip.item_id,
804: ppar.master_organization_id,
805: uom.unit_of_measure,
806: pitem.primary_uom_code

Line 878: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))

874: ponip.item_id,
875: null,
876: decode(pll.value_basis,'AMOUNT',1,
877: decode(uom.unit_of_measure,nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code), 1,
878: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
879: ,
880: decode(uom.unit_of_measure,
881: pitem.primary_unit_of_measure, 1,
882: poa_dbi_uom_pkg.convert_to_item_base_uom(

Line 882: poa_dbi_uom_pkg.convert_to_item_base_uom(

878: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
879: ,
880: decode(uom.unit_of_measure,
881: pitem.primary_unit_of_measure, 1,
882: poa_dbi_uom_pkg.convert_to_item_base_uom(
883: ponip.item_id,
884: ppar.master_organization_id,
885: uom.unit_of_measure,
886: pitem.primary_uom_code

Line 969: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))

965: ponip.item_id,
966: null,
967: decode(pll.value_basis,'AMOUNT',1,
968: decode(uom.unit_of_measure,nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code), 1,
969: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
970: ,
971: decode(uom.unit_of_measure,
972: pitem.primary_unit_of_measure, 1,
973: poa_dbi_uom_pkg.convert_to_item_base_uom(

Line 973: poa_dbi_uom_pkg.convert_to_item_base_uom(

969: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
970: ,
971: decode(uom.unit_of_measure,
972: pitem.primary_unit_of_measure, 1,
973: poa_dbi_uom_pkg.convert_to_item_base_uom(
974: ponip.item_id,
975: ppar.master_organization_id,
976: uom.unit_of_measure,
977: pitem.primary_uom_code

Line 1044: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))

1040: ponip.item_id,
1041: null,
1042: decode(pll.value_basis,'AMOUNT',1,
1043: decode(uom.unit_of_measure,nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code), 1,
1044: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
1045: ,
1046: decode(uom.unit_of_measure,
1047: pitem.primary_unit_of_measure, 1,
1048: poa_dbi_uom_pkg.convert_to_item_base_uom(

Line 1048: poa_dbi_uom_pkg.convert_to_item_base_uom(

1044: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
1045: ,
1046: decode(uom.unit_of_measure,
1047: pitem.primary_unit_of_measure, 1,
1048: poa_dbi_uom_pkg.convert_to_item_base_uom(
1049: ponip.item_id,
1050: ppar.master_organization_id,
1051: uom.unit_of_measure,
1052: pitem.primary_uom_code

Line 1124: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))

1120: ponip.item_id,
1121: null,
1122: decode(pll.value_basis,'AMOUNT',1,
1123: decode(uom.unit_of_measure,nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code), 1,
1124: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
1125: ,
1126: decode(uom.unit_of_measure,
1127: pitem.primary_unit_of_measure, 1,
1128: poa_dbi_uom_pkg.convert_to_item_base_uom(

Line 1128: poa_dbi_uom_pkg.convert_to_item_base_uom(

1124: poa_dbi_uom_pkg.convert_neg_to_po_uom(uom.unit_of_measure, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))))
1125: ,
1126: decode(uom.unit_of_measure,
1127: pitem.primary_unit_of_measure, 1,
1128: poa_dbi_uom_pkg.convert_to_item_base_uom(
1129: ponip.item_id,
1130: ppar.master_organization_id,
1131: uom.unit_of_measure,
1132: pitem.primary_uom_code

Line 1732: poa_dbi_uom_pkg.convert_to_item_base_uom(pol.item_id, par.master_organization_id, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code) ,item.primary_uom_code ))) base_uom_conv_rate,

1728: pod.code_combination_id, -- not used for now
1729: Nvl(poa_gl.currency_code, 'DBI_ERR') CURRENCY_CODE,
1730: rat.GLOBAL_CUR_CONV_RATE,
1731: decode(pol.item_id, null, 1, decode(nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code), item.primary_unit_of_measure, 1,
1732: poa_dbi_uom_pkg.convert_to_item_base_uom(pol.item_id, par.master_organization_id, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code) ,item.primary_uom_code ))) base_uom_conv_rate,
1733: decode(pll.matching_basis,
1734: 'AMOUNT',
1735: Nvl(pod.amount_ordered,0) - Nvl(pod.amount_cancelled,0),
1736: (Nvl(pod.quantity_ordered,0) - Nvl(pod.quantity_cancelled,0)) * Nvl(pll.price_override,0)

Line 2002: decode(pol.item_id, null, 1, poa_dbi_uom_pkg.convert_to_item_base_uom(pol.item_id, par.master_organization_id, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))) base_uom_conv_rate,

1998: --Nvl(pod.rate, 1) FUNC_CUR_CONV_RATE,
1999: /* poa_dbi_currency_pkg.get_global_currency_rate(poh.rate_type, poh.currency_code, NVL(pod.rate_date,
2000: pod.creation_date), pod.rate) GLOBAL_CUR_CONV_RATE, */
2001: rat.GLOBAL_CUR_CONV_RATE,
2002: decode(pol.item_id, null, 1, poa_dbi_uom_pkg.convert_to_item_base_uom(pol.item_id, par.master_organization_id, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code))) base_uom_conv_rate,
2003: (case when pll.matching_basis = 'AMOUNT'
2004: then (Nvl(pod.amount_ordered,0) - Nvl(pod.amount_cancelled,0))
2005: else (Nvl(pod.quantity_ordered,0) - Nvl(pod.quantity_cancelled,0)) * Nvl(pll.price_override,0)
2006: end) purchase_amount,

Line 2106: then decode(pol.item_id, null, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code), poa_dbi_uom_pkg.get_item_base_uom(pol.item_id, par.master_organization_id, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code)))

2102: pol.from_header_id from_document_id,
2103: (case when (pll.consigned_flag = 'Y') then 1
2104: when ((por.consigned_consumption_flag = 'Y') or (poh.consigned_consumption_flag = 'Y')) then 2 else 0 end) consigned_code,
2105: (case when pll.value_basis = 'QUANTITY'
2106: then decode(pol.item_id, null, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code), poa_dbi_uom_pkg.get_item_base_uom(pol.item_id, par.master_organization_id, nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code)))
2107: else null
2108: end) base_uom,
2109: (case when pll.value_basis = 'QUANTITY'
2110: then nvl(pll.unit_meas_lookup_code, pol.unit_meas_lookup_code)