DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on CST_COST_GROUPS

Line 744: FROM cst_cost_groups

740: OPEN x_cost_group FOR
741: SELECT cost_group
742: , cost_group_id
743: , description
744: FROM cst_cost_groups
745: WHERE NVL(organization_id, p_organization_id) = p_organization_id
746: AND cost_group_type = 3
747: AND cost_group LIKE (p_cost_group)
748: AND cost_group_id IN (SELECT cost_group_id

Line 2267: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms

2263: , mil.concatenated_segments
2264: , msn.revision
2265: , msn.cost_group_id
2266: , ccg.cost_group
2267: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2268: WHERE (group_mark_id IS NULL
2269: OR group_mark_id = -1
2270: )
2271: AND mms.status_id(+) = msn.status_id

Line 2305: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms

2301: , mil.concatenated_segments
2302: , msn.revision
2303: , msn.cost_group_id
2304: , ccg.cost_group
2305: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2306: WHERE (group_mark_id IS NULL
2307: OR group_mark_id = -1
2308: )
2309: AND mms.status_id(+) = msn.status_id