DBA Data[Home] [Help]

APPS.CSP_TRANSACTIONS_PUB dependencies on CSP_STOCKING_SITE_DETAILS_V

Line 3127: from csp_stocking_site_details_v

3123: and secondary_inventory_name = cp_subinv;
3124:
3125: CURSOR getStockingSiteType(cp_org_id number, cp_subinv varchar2) IS
3126: select nvl(stocking_site_type, 'TECHNICIAN')
3127: from csp_stocking_site_details_v
3128: where organization_id = cp_org_id
3129: and nvl(subinventory_code, 'NULL') = nvl(cp_subinv, 'NULL');
3130:
3131: CURSOR getIntransitDetail(cp_s_org_id number, cp_d_org_id number) IS