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 1741: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq

1737: IF p_lpn_id IS NULL THEN
1738: IF p_serial_number IS NULL THEN
1739: SELECT ccg.cost_group_id, ccg.cost_group
1740: INTO x_cost_group_id, x_cost_group
1741: FROM cst_cost_groups ccg, mtl_onhand_quantities_detail moq
1742: WHERE ccg.cost_group_id = moq.cost_group_id
1743: AND (moq.lot_number = p_lot_number
1744: OR (p_lot_number IS NULL AND moq.lot_number IS NULL))
1745: AND (moq.revision = p_revision

Line 1760: FROM cst_cost_groups ccg, mtl_serial_numbers msn

1756: GROUP BY ccg.cost_group_id, ccg.cost_group;
1757: ELSE
1758: SELECT ccg.cost_group_id, ccg.cost_group
1759: INTO x_cost_group_id, x_cost_group
1760: FROM cst_cost_groups ccg, mtl_serial_numbers msn
1761: WHERE ccg.cost_group_id = msn.cost_group_id
1762: AND (msn.lot_number = p_lot_number
1763: OR (p_lot_number IS NULL AND msn.lot_number IS NULL))
1764: AND (msn.revision = p_revision

Line 1781: FROM cst_cost_groups ccg, wms_lpn_contents wlc,

1777: ELSE
1778: IF p_serial_number IS NULL THEN
1779: SELECT ccg.cost_group_id, ccg.cost_group
1780: INTO x_cost_group_id, x_cost_group
1781: FROM cst_cost_groups ccg, wms_lpn_contents wlc,
1782: wms_license_plate_numbers wlpn
1783: WHERE ccg.cost_group_id = wlc.cost_group_id
1784: AND (wlc.lot_number = p_lot_number
1785: OR (p_lot_number IS NULL AND wlc.lot_number IS NULL))

Line 1798: FROM cst_cost_groups ccg, mtl_serial_numbers msn

1794: GROUP BY ccg.cost_group_id, ccg.cost_group;
1795: ELSE
1796: SELECT ccg.cost_group_id, ccg.cost_group
1797: INTO x_cost_group_id, x_cost_group
1798: FROM cst_cost_groups ccg, mtl_serial_numbers msn
1799: WHERE ccg.cost_group_id = msn.cost_group_id
1800: AND (msn.lot_number = p_lot_number
1801: OR (p_lot_number IS NULL AND msn.lot_number IS NULL))
1802: AND (msn.revision = p_revision