APPS.INV_COST_GROUP_PVT dependencies on CST_COST_GROUPS

Line 88: from cst_cost_groups

84: for i in 1..l_count
85: loop
86: select cost_group
87: into l_cost_group
88: from cst_cost_groups
89: where cost_group_id = l_cost_group_id_tbl(i);
90:
91: if l_cost_group = p_cost_group then
92: x_cost_group_id := l_cost_group_id_tbl(i);

Line 1676: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

1672: IF p_lpn_id IS NULL THEN
1673: IF p_serial_number IS NULL THEN
1674: SELECT ccg.cost_group_id, ccg.cost_group
1675: INTO x_cost_group_id, x_cost_group
1676: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
1677: WHERE ccg.cost_group_id = moq.cost_group_id
1678: AND (moq.lot_number = p_lot_number
1679: OR (p_lot_number IS NULL AND moq.lot_number IS NULL))
1680: AND (moq.revision = p_revision

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 1716: FROM cst_cost_groups ccg, wms_lpn_contents wlc,

1712: ELSE
1713: IF p_serial_number IS NULL THEN
1714: SELECT ccg.cost_group_id, ccg.cost_group
1715: INTO x_cost_group_id, x_cost_group
1716: FROM cst_cost_groups ccg, wms_lpn_contents wlc,
1717: wms_license_plate_numbers wlpn
1718: WHERE ccg.cost_group_id = wlc.cost_group_id
1719: AND (wlc.lot_number = p_lot_number
1720: OR (p_lot_number IS NULL AND wlc.lot_number IS NULL))

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