DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on INV_CONVERT

Line 2675: inv_convert.inv_um_convert(

2671: cedi.organization_id,
2672: cedi.task_number,
2673: cedi.item_id,
2674: SUM(
2675: inv_convert.inv_um_convert(
2676: cedi.item_id, NULL, cedi.quantity_ordered,
2677: cedi.uom_code, msi.primary_uom_code, NULL, NULL
2678: )
2679: /* We convert to primary_uom because the required_quantity in

Line 2735: inv_convert.inv_um_convert(

2731: NVL(wedi.required_quantity,0) -
2732: SUM(
2733: /* Sum is needed because there could be multiple
2734: POs/Reqs for the same description item */
2735: inv_convert.inv_um_convert(
2736: NULL, NULL, NVL(wediv.quantity_ordered,0),
2737: NVL(wediv.uom_code, wedi.uom), wedi.uom, NULL, NULL
2738: )
2739: )

Line 2745: inv_convert.inv_um_convert(

2741: 1,
2742: (
2743: NVL(wedi.required_quantity,0) -
2744: SUM(
2745: inv_convert.inv_um_convert(
2746: NULL, NULL, NVL(wediv.quantity_ordered,0),
2747: NVL(wediv.uom_code, wedi.uom), wedi.uom, NULL, NULL
2748: )
2749: )

Line 4287: inv_convert.inv_um_convert(

4283: cedi.organization_id,
4284: cedi.task_number,
4285: cedi.item_id,
4286: SUM(
4287: inv_convert.inv_um_convert(
4288: cedi.item_id, NULL, cedi.quantity_ordered,
4289: cedi.uom_code, msi.primary_uom_code, NULL, NULL
4290: )
4291: /* We convert to primary_uom because the required_quantity in

Line 4545: inv_convert.inv_um_convert(

4541: (NVL(wedi.required_quantity,0) -
4542: SUM(
4543: /* Sum is needed because there could be multiple
4544: POs/Reqs for the same description item */
4545: inv_convert.inv_um_convert(
4546: NULL, NULL, NVL(cedi.quantity_ordered,0),
4547: NVL(cedi.uom_code, wedi.uom), wedi.uom, NULL, NULL
4548: )
4549: )

Line 4564: inv_convert.inv_um_convert(

4560: NVL(wedi.required_quantity,0) -
4561: SUM(
4562: /* Sum is needed because there could be multiple
4563: POs/Reqs for the same description item */
4564: inv_convert.inv_um_convert(
4565: NULL, NULL, NVL(cedi.quantity_ordered,0),
4566: NVL(cedi.uom_code, wedi.uom), wedi.uom, NULL, NULL
4567: )
4568: )),

Line 4604: inv_convert.inv_um_convert(

4600: DECODE(cedi.order_type_lookup_code,
4601: 'FIXED PRICE',NVL(wedi.amount,0) - sum(NVL(cedi.amount_delivered,0)),
4602: 'RATE',NVL(wedi.amount,0) - sum(NVL(cedi.amount_delivered,0)),
4603: NVL(wedi.required_quantity,0) - SUM(
4604: inv_convert.inv_um_convert(
4605: NULL, NULL, NVL(cedi.quantity_ordered,0),
4606: NVL(cedi.uom_code, wedi.uom), wedi.uom, NULL, NULL
4607: )
4608: )) > 0;

Line 6094: l_directItem_rec.primary_quantity := inv_convert.inv_um_convert(

6090: from mtl_system_items_b msi
6091: where msi.inventory_item_id = l_item_id
6092: and msi.organization_id = l_directItem_rec.organization_id;
6093:
6094: l_directItem_rec.primary_quantity := inv_convert.inv_um_convert(
6095: l_item_id,
6096: NULL,
6097: l_directItem_rec.transaction_quantity, -- TRX quantity
6098: l_directItem_rec.transaction_uom, -- TRX UOM