DBA Data[Home] [Help]

APPS.INV_UI_ITEM_ATT_LOVS dependencies on CST_COST_GROUPS

Line 686: FROM cst_cost_groups

682: OPEN x_cost_group FOR
683: SELECT cost_group
684: , cost_group_id
685: , description
686: FROM cst_cost_groups
687: WHERE NVL(organization_id, p_organization_id) = p_organization_id
688: AND cost_group_type = 3
689: AND cost_group LIKE (p_cost_group)
690: AND cost_group_id IN (SELECT cost_group_id

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

2176: , mil.concatenated_segments
2177: , msn.revision
2178: , msn.cost_group_id
2179: , ccg.cost_group
2180: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2181: WHERE (group_mark_id IS NULL
2182: OR group_mark_id = -1
2183: )
2184: AND mms.status_id(+) = msn.status_id

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

2214: , mil.concatenated_segments
2215: , msn.revision
2216: , msn.cost_group_id
2217: , ccg.cost_group
2218: FROM mtl_item_locations_kfv mil, mtl_serial_numbers msn, cst_cost_groups ccg, mtl_material_statuses_tl mms
2219: WHERE (group_mark_id IS NULL
2220: OR group_mark_id = -1
2221: )
2222: AND mms.status_id(+) = msn.status_id