APPS.INV_RCV_STD_RCPT_APIS dependencies on CST_COST_GROUP_ACCOUNTS

Line 4527: FROM cst_cost_group_accounts

4523: WHERE organization_id = p_organization_id
4524: AND parent_lpn_id = p_lpn_id
4525: AND wlpnc.inventory_item_id = p_item_id
4526: AND EXISTS(SELECT 1
4527: FROM cst_cost_group_accounts
4528: WHERE organization_id = p_organization_id
4529: AND cost_group_id = wlpnc.cost_group_id);
4530: EXCEPTION
4531: WHEN OTHERS THEN

Line 4542: FROM cst_cost_group_accounts

4538: WHERE organization_id = p_organization_id
4539: AND parent_lpn_id = p_from_lpn_id
4540: AND wlpnc.inventory_item_id = p_item_id
4541: AND NOT EXISTS(SELECT 1
4542: FROM cst_cost_group_accounts
4543: WHERE organization_id = p_organization_id
4544: AND cost_group_id = wlpnc.cost_group_id);
4545: END IF;
4546: END IF;

Line 6954: FROM cst_cost_group_accounts

6950: AND wlpnc.inventory_item_id = p_item_id
6951: AND Nvl(wlpnc.lot_number,'@@@') = Nvl(l_lot_qty_rec_tb(i).lot_number,Nvl(wlpnc.lot_number,'@@@'))
6952: AND EXISTS(
6953: SELECT 1
6954: FROM cst_cost_group_accounts
6955: WHERE organization_id = p_org_id
6956: AND cost_group_id = wlpnc.cost_group_id);
6957: EXCEPTION
6958: WHEN OTHERS THEN

Line 6969: FROM cst_cost_group_accounts

6965: FROM rcv_shipment_lines rsl
6966: WHERE shipment_line_id = p_shipment_line_id
6967: AND exists (
6968: SELECT 1
6969: FROM cst_cost_group_accounts
6970: WHERE organization_id = p_org_id
6971: AND cost_group_id = rsl.cost_group_id)
6972: AND ROWNUM = 1;
6973: EXCEPTION

Line 7086: FROM cst_cost_group_accounts

7082: AND parent_lpn_id = p_lpn
7083: AND wlpnc.inventory_item_id = p_item_id
7084: AND EXISTS(
7085: SELECT 1
7086: FROM cst_cost_group_accounts
7087: WHERE organization_id = p_org_id
7088: AND cost_group_id = wlpnc.cost_group_id);
7089: EXCEPTION
7090: WHEN OTHERS THEN

Line 7101: FROM cst_cost_group_accounts

7097: FROM rcv_shipment_lines rsl
7098: WHERE shipment_line_id = p_shipment_line_id
7099: AND exists (
7100: SELECT 1
7101: FROM cst_cost_group_accounts
7102: WHERE organization_id = p_org_id
7103: AND cost_group_id = rsl.cost_group_id)
7104: AND ROWNUM = 1;
7105: EXCEPTION