DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on INV_CONVERT

Line 2897: inv_convert.inv_um_convert(

2893: cedi.organization_id,
2894: cedi.task_number,
2895: cedi.item_id,
2896: SUM(
2897: inv_convert.inv_um_convert(
2898: cedi.item_id, NULL, cedi.quantity_ordered,
2899: cedi.uom_code, msi.primary_uom_code, NULL, NULL
2900: )
2901: /* We convert to primary_uom because the required_quantity in

Line 2957: inv_convert.inv_um_convert(

2953: NVL(wedi.required_quantity,0) -
2954: SUM(
2955: /* Sum is needed because there could be multiple
2956: POs/Reqs for the same description item */
2957: inv_convert.inv_um_convert(
2958: NULL, NULL, NVL(wediv.quantity_ordered,0),
2959: NVL(wediv.uom_code, wedi.uom), wedi.uom, NULL, NULL
2960: )
2961: )

Line 2967: inv_convert.inv_um_convert(

2963: 1,
2964: (
2965: NVL(wedi.required_quantity,0) -
2966: SUM(
2967: inv_convert.inv_um_convert(
2968: NULL, NULL, NVL(wediv.quantity_ordered,0),
2969: NVL(wediv.uom_code, wedi.uom), wedi.uom, NULL, NULL
2970: )
2971: )

Line 4509: inv_convert.inv_um_convert(

4505: cedi.organization_id,
4506: cedi.task_number,
4507: cedi.item_id,
4508: SUM(
4509: inv_convert.inv_um_convert(
4510: cedi.item_id, NULL, cedi.quantity_ordered,
4511: cedi.uom_code, msi.primary_uom_code, NULL, NULL
4512: )
4513: /* We convert to primary_uom because the required_quantity in

Line 4767: inv_convert.inv_um_convert(

4763: (NVL(wedi.required_quantity,0) -
4764: SUM(
4765: /* Sum is needed because there could be multiple
4766: POs/Reqs for the same description item */
4767: inv_convert.inv_um_convert(
4768: NULL, NULL, NVL(cedi.quantity_ordered,0),
4769: NVL(cedi.uom_code, wedi.uom), wedi.uom, NULL, NULL
4770: )
4771: )

Line 4786: inv_convert.inv_um_convert(

4782: NVL(wedi.required_quantity,0) -
4783: SUM(
4784: /* Sum is needed because there could be multiple
4785: POs/Reqs for the same description item */
4786: inv_convert.inv_um_convert(
4787: NULL, NULL, NVL(cedi.quantity_ordered,0),
4788: NVL(cedi.uom_code, wedi.uom), wedi.uom, NULL, NULL
4789: )
4790: )),

Line 4826: inv_convert.inv_um_convert(

4822: DECODE(cedi.order_type_lookup_code,
4823: 'FIXED PRICE',NVL(wedi.amount,0) - sum(NVL(cedi.amount_delivered,0)),
4824: 'RATE',NVL(wedi.amount,0) - sum(NVL(cedi.amount_delivered,0)),
4825: NVL(wedi.required_quantity,0) - SUM(
4826: inv_convert.inv_um_convert(
4827: NULL, NULL, NVL(cedi.quantity_ordered,0),
4828: NVL(cedi.uom_code, wedi.uom), wedi.uom, NULL, NULL
4829: )
4830: )) > 0;

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

6444: from mtl_system_items_b msi
6445: where msi.inventory_item_id = l_item_id
6446: and msi.organization_id = l_directItem_rec.organization_id;
6447:
6448: l_directItem_rec.primary_quantity := inv_convert.inv_um_convert(
6449: l_item_id,
6450: NULL,
6451: l_directItem_rec.transaction_quantity, -- TRX quantity
6452: l_directItem_rec.transaction_uom, -- TRX UOM