APPS.INV_RCV_STD_RCPT_APIS dependencies on CST_COST_GROUP_ACCOUNTS

Line 4271: FROM cst_cost_group_accounts

4267: WHERE organization_id = p_organization_id
4268: AND parent_lpn_id = p_lpn_id
4269: AND wlpnc.inventory_item_id = p_item_id
4270: AND EXISTS(SELECT 1
4271: FROM cst_cost_group_accounts
4272: WHERE organization_id = p_organization_id
4273: AND cost_group_id = wlpnc.cost_group_id);
4274: EXCEPTION
4275: WHEN OTHERS THEN

Line 4286: FROM cst_cost_group_accounts

4282: WHERE organization_id = p_organization_id
4283: AND parent_lpn_id = p_from_lpn_id
4284: AND wlpnc.inventory_item_id = p_item_id
4285: AND NOT EXISTS(SELECT 1
4286: FROM cst_cost_group_accounts
4287: WHERE organization_id = p_organization_id
4288: AND cost_group_id = wlpnc.cost_group_id);
4289: END IF;
4290: END IF;

Line 6599: FROM cst_cost_group_accounts

6595: AND wlpnc.inventory_item_id = p_item_id
6596: AND Nvl(wlpnc.lot_number,'@@@') = Nvl(l_lot_qty_rec_tb(i).lot_number,Nvl(wlpnc.lot_number,'@@@'))
6597: AND EXISTS(
6598: SELECT 1
6599: FROM cst_cost_group_accounts
6600: WHERE organization_id = p_org_id
6601: AND cost_group_id = wlpnc.cost_group_id);
6602: EXCEPTION
6603: WHEN OTHERS THEN

Line 6614: FROM cst_cost_group_accounts

6610: FROM rcv_shipment_lines rsl
6611: WHERE shipment_line_id = p_shipment_line_id
6612: AND exists (
6613: SELECT 1
6614: FROM cst_cost_group_accounts
6615: WHERE organization_id = p_org_id
6616: AND cost_group_id = rsl.cost_group_id)
6617: AND ROWNUM = 1;
6618: EXCEPTION

Line 6731: FROM cst_cost_group_accounts

6727: AND parent_lpn_id = p_lpn
6728: AND wlpnc.inventory_item_id = p_item_id
6729: AND EXISTS(
6730: SELECT 1
6731: FROM cst_cost_group_accounts
6732: WHERE organization_id = p_org_id
6733: AND cost_group_id = wlpnc.cost_group_id);
6734: EXCEPTION
6735: WHEN OTHERS THEN

Line 6746: FROM cst_cost_group_accounts

6742: FROM rcv_shipment_lines rsl
6743: WHERE shipment_line_id = p_shipment_line_id
6744: AND exists (
6745: SELECT 1
6746: FROM cst_cost_group_accounts
6747: WHERE organization_id = p_org_id
6748: AND cost_group_id = rsl.cost_group_id)
6749: AND ROWNUM = 1;
6750: EXCEPTION