DBA Data[Home] [Help]

APPS.INV_CONSIGNED_VALIDATIONS dependencies on INV_DECIMALS_PUB

Line 2719: SELECT SUM(inv_decimals_pub.get_primary_quantity( p_org_id

2715:
2716: END IF;
2717:
2718: -- Bug 4209192, adding below query to account for undelivered LPNs for WIP assembly completions.
2719: SELECT SUM(inv_decimals_pub.get_primary_quantity( p_org_id
2720: ,p_item_id
2721: ,mtrl.uom_code
2722: ,mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2723: )

Line 3583: SELECT SUM(inv_decimals_pub.get_primary_quantity( p_org_id

3579: END IF;
3580: /* End of changes for bug 7193862 */
3581:
3582: -- Bug 4189319, adding below query to account for undelivered LPNs for WIP assembly completions.
3583: SELECT SUM(inv_decimals_pub.get_primary_quantity( p_org_id
3584: ,p_item_id
3585: ,mtrl.uom_code
3586: ,mtrl.quantity - NVL(mtrl.quantity_delivered,0))
3587: )