DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_SUBINVENTORY_EXTENSIONS

Line 651: WSM_SUBINVENTORY_EXTENSIONS WSUE

647: IF x_accounting_class_code IS NULL THEN
648: SELECT WSE.DEFAULT_ACCT_CLASS_CODE
649: INTO x_accounting_class_code
650: FROM WSM_SECTOR_EXTENSIONS WSE,
651: WSM_SUBINVENTORY_EXTENSIONS WSUE
652: WHERE WSUE.organization_id = p_organization_id
653: AND WSUE.secondary_inventory_name = p_subinventory_name
654: AND WSUE.sector_extension_id = WSE.sector_extension_id
655: AND WSUE.organization_id = WSE.organization_id;

Line 2531: from wsm_subinventory_extensions

2527:
2528: BEGIN
2529: select 1
2530: into l_dummy
2531: from wsm_subinventory_extensions
2532: where secondary_inventory_name = p_completion_subinventory
2533: and organization_id = p_organization_id;
2534: EXCEPTION
2535: when too_many_rows then null;