DBA Data[Home] [Help]

APPS.CST_PACEAMCOST_GRP dependencies on INV_CONVERT

Line 1368: SUM(inv_convert.inv_um_convert(ced.item_id,

1364: (SELECT ced.work_order_number,
1365: ced.organization_id,
1366: ced.task_number,
1367: ced.item_id,
1368: SUM(inv_convert.inv_um_convert(ced.item_id,
1369: NULL,
1370: ced.quantity_ordered,
1371: ced.uom_code,
1372: msi.primary_uom_code,

Line 1423: - SUM(inv_convert.inv_um_convert(NULL,

1419: DECODE(cedit.order_type_lookup_code,
1420: 'FIXED PRICE', NVL(wedi.amount,0) * NVL(cedit.currency_rate,1) - sum( NVL(cedit.amount_delivered ,0)),
1421: 'RATE', NVL(wedi.amount,0) * NVL(cedit.currency_rate,1) - sum(NVL(cedit.amount_delivered ,0)),
1422: DECODE(SIGN(NVL(wedi.required_quantity,0)
1423: - SUM(inv_convert.inv_um_convert(NULL,
1424: NULL,
1425: NVL(cedit.quantity_ordered,0),
1426: NVL(cedit.uom_code, wedi.uom),
1427: wedi.uom,

Line 1431: - SUM(inv_convert.inv_um_convert(NULL,

1427: wedi.uom,
1428: NULL,
1429: NULL))),
1430: 1, (NVL(wedi.required_quantity,0)
1431: - SUM(inv_convert.inv_um_convert(NULL,
1432: NULL,
1433: NVL(cedit.quantity_ordered,0),
1434: NVL(cedit.uom_code, wedi.uom),
1435: wedi.uom,