APPS.GMF_LOT_COSTING_PUB dependencies on INV_CONVERT

Line 372: -- 9) inv_convert only when different

368: -- C3 Changes.
369: -- 7) Load only lot costs from prior 60 days.
370: -- C4 Changes.
371: -- 8) Burden indicater.
372: -- 9) inv_convert only when different
373: -- 10) inv_tran_cursor, no mtl_system_items in lot cost adjustment query section.
374: -- 11) Removing Le_id join for process_org_gt table
375: -- 12) suggesting following
376: --CREATE INDEX gmf_lot_costed_items_gt_N1 ON gmf_lot_costed_items_gt

Line 2744: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => transaction_row.inventory_item_id

2740: /* For non-LCM charges only invoke uom conversion */
2741: l_from_uom := l_acq_tab(i).receipt_uom;
2742: IF (transaction_row.trans_um <> l_from_uom AND l_acq_tab(i).lcm_flag = 0) THEN
2743: l_acquisition_cost :=
2744: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => transaction_row.inventory_item_id
2745: ,PRECISION => 5
2746: ,ORGANIZATION_ID => transaction_row.orgn_id
2747: ,LOT_NUMBER => transaction_row.lot_number
2748: ,FROM_QUANTITY => l_acq_tab(i).component_cost

Line 4402: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => transaction_row.inventory_item_id

4398: );
4399: END IF;
4400: lot_unit_cost := 0 ;
4401: lot_unit_cost :=
4402: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => transaction_row.inventory_item_id
4403: ,LOT_NUMBER => transaction_row.lot_number
4404: ,ORGANIZATION_ID => transaction_row.orgn_id
4405: ,PRECISION => 5
4406: ,FROM_QUANTITY => receipt_unit_cost

Line 5804: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => l_step_tab(1).materials(j).item_id

5800: IF l_step_tab(1).materials(j).trans_um <> l_step_tab(1).step_qty_uom THEN
5801:
5802: l_tran_qty := 0; -- B9131983
5803: l_tran_qty :=
5804: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => l_step_tab(1).materials(j).item_id
5805: ,LOT_NUMBER => l_step_tab(1).materials(j).lot_number
5806: ,PRECISION => 5
5807: ,ORGANIZATION_ID => transaction_row.orgn_id
5808: ,FROM_QUANTITY => -l_step_tab(1).materials(j).trans_qty

Line 5873: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => l_step_tab(i).materials(j).item_id

5869: IF l_step_tab(i).materials(j).trans_um <> l_step_tab(i).step_qty_uom THEN
5870:
5871: l_tran_qty := 0; -- B9131983
5872: l_tran_qty :=
5873: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => l_step_tab(i).materials(j).item_id
5874: ,LOT_NUMBER => l_step_tab(i).materials(j).lot_number
5875: ,PRECISION => 5
5876: ,ORGANIZATION_ID => transaction_row.orgn_id
5877: ,FROM_QUANTITY => nvl(l_step_output_qty, l_step_tab(i).materials(j).trans_qty)

Line 6556: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => l_step_tab(i).materials(j).item_id

6552: -- Bug 3548217
6553: IF l_step_tab(i).step_qty_uom <> l_step_tab(i).materials(j).trans_um THEN
6554: l_tran_qty := 0; -- B9131983
6555: l_tran_qty :=
6556: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => l_step_tab(i).materials(j).item_id
6557: ,LOT_NUMBER => l_step_tab(i).materials(j).lot_number
6558: ,PRECISION => 5
6559: ,ORGANIZATION_ID => transaction_row.orgn_id
6560: ,FROM_QUANTITY => l_step_tab(i).materials(j).trans_qty

Line 6686: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => l_step_tab(i).materials(j).item_id

6682: IF l_step_tab(i).materials(j).line_um <> l_step_tab(i).materials(j).trans_um THEN
6683:
6684: /* Rajesh Patangya B9131983 Starts */
6685: l_actual_line_qty :=
6686: INV_CONVERT.INV_UM_CONVERT(ITEM_ID => l_step_tab(i).materials(j).item_id
6687: ,LOT_NUMBER => l_step_tab(i).materials(j).lot_number
6688: ,PRECISION => 5
6689: ,ORGANIZATION_ID => transaction_row.orgn_id
6690: ,FROM_QUANTITY => l_step_tab(i).materials(j).actual_line_qty