DBA Data[Home] [Help]

APPS.INV_COST_GROUP_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1695: FROM cst_cost_groups ccg, mtl_serial_numbers msn

1691: GROUP BY ccg.cost_group_id, ccg.cost_group;
1692: ELSE
1693: SELECT ccg.cost_group_id, ccg.cost_group
1694: INTO x_cost_group_id, x_cost_group
1695: FROM cst_cost_groups ccg, mtl_serial_numbers msn
1696: WHERE ccg.cost_group_id = msn.cost_group_id
1697: AND (msn.lot_number = p_lot_number
1698: OR (p_lot_number IS NULL AND msn.lot_number IS NULL))
1699: AND (msn.revision = p_revision

Line 1733: FROM cst_cost_groups ccg, mtl_serial_numbers msn

1729: GROUP BY ccg.cost_group_id, ccg.cost_group;
1730: ELSE
1731: SELECT ccg.cost_group_id, ccg.cost_group
1732: INTO x_cost_group_id, x_cost_group
1733: FROM cst_cost_groups ccg, mtl_serial_numbers msn
1734: WHERE ccg.cost_group_id = msn.cost_group_id
1735: AND (msn.lot_number = p_lot_number
1736: OR (p_lot_number IS NULL AND msn.lot_number IS NULL))
1737: AND (msn.revision = p_revision