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.INV_MINMAX_PVT dependencies on INV_DECIMALS_PUB

Line 1186: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id

1182: AND mtrl.line_status NOT IN (5,6)
1183: AND mtrl.date_required <= p_s_cutoff;*/
1184:
1185: /*4518296*/
1186: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id
1187: ,p_item_id
1188: , mtrl.uom_code
1189: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
1190: ),0)

Line 1575: select SUM(inv_decimals_pub.get_primary_quantity( ship_from_org_id

1571: -- Bug 3480523, from patch I onwards schedule_ship_date is being populated
1572: -- with time component, hence truncating it to get the same day demand. These
1573: -- changes are also in mtl_reservation queries.
1574: if p_net_unrsv = 1 then
1575: select SUM(inv_decimals_pub.get_primary_quantity( ship_from_org_id
1576: , inventory_item_id
1577: , order_quantity_uom
1578: , NVL(ordered_quantity,0)) -
1579: get_shipped_qty(p_org_id, p_item_id, ool.line_id)),

Line 1811: select SUM(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY( SHIP_FROM_ORG_ID

1807: -- orig_sys_document_ref and orig_sys_line_ref to identify requisitions
1808: -- and requisition lines uniquely.
1809:
1810: if p_net_unrsv = 1 then
1811: select SUM(INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY( SHIP_FROM_ORG_ID
1812: , INVENTORY_ITEM_ID
1813: , ORDER_QUANTITY_UOM
1814: , NVL(ordered_quantity,0)) -
1815: get_shipped_qty(p_org_id, p_item_id, so.line_id))

Line 2014: SUM (INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY( p_org_id

2010: above from mtl_reservations query. */
2011:
2012:
2013: SELECT
2014: SUM (INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY( p_org_id
2015: , p_item_id
2016: , d.dtl_um
2017: , NVL(NVL(d.wip_plan_qty, d.plan_qty) - d.actual_qty, 0))-
2018: NVL(mtr.primary_reservation_quantity,0))

Line 2034: AND (INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY( p_org_id

2030: AND d.batch_id = mtr.demand_source_header_id (+)
2031: AND d.material_detail_id = mtr.demand_source_line_id (+)
2032: AND d.inventory_item_id = mtr.inventory_item_id (+)
2033: AND d.organization_id = mtr.organization_id (+)
2034: AND (INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY( p_org_id
2035: , p_item_id
2036: , d.dtl_um
2037: , NVL(NVL(d.wip_plan_qty, d.plan_qty) - d.actual_qty, 0))-
2038: NVL(mtr.primary_reservation_quantity,0)) > 0

Line 2164: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id

2160: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
2161: 1,S.AVAILABILITY_TYPE,1)))
2162: AND MTRL.DATE_REQUIRED <= p_d_cutoff;*/
2163:
2164: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id
2165: ,p_item_id
2166: , mtrl.uom_code
2167: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2168: ),0)

Line 2237: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id

2233: AND mtrl.from_subinventory_code = p_subinv
2234: AND mtrl.line_status NOT IN (5,6)
2235: AND mtrl.date_required <= p_d_cutoff;*/
2236:
2237: SELECT NVL(SUM(inv_decimals_pub.get_primary_quantity( p_org_id
2238: ,p_item_id
2239: ,mtrl.uom_code
2240: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2241: ),0)