DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on CST_ITEM_COSTS

Line 3143: ,value3 --the item cost in Pri UOM and Pri Currency, from cst_item_costs table

3139: ,shikyu_price
3140: ,item_cost --the cost based on UOM after conversion from Pri_Uom
3141: ,value1 --the item qty in Pri Uom
3142: ,value2 --the item price in Pri UOM and Pri Currency
3143: ,value3 --the item cost in Pri UOM and Pri Currency, from cst_item_costs table
3144: ,project_id
3145: ,project_num
3146: ,task_id
3147: ,task_num

Line 3303: ,cst_item_costs cic

3299: ,po_line_locations_all plla_s
3300: ,po_headers_all pha_s
3301: ,po_lines_all pla_s
3302: ,po_releases_all pra_s
3303: ,cst_item_costs cic
3304: WHERE cfr_mid.row_type = CFR_TMP_RCV_ROW
3305: AND cfr_mid.oem_inv_org_id = mp_oem.organization_id
3306: AND cfr_mid.tp_inv_org_id = mp_tp.organization_id
3307: AND cfr_mid.supplier_id = pv.vendor_id(+)