DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on WSM_SECTOR_EXTENSIONS

Line 1913: wsm_sector_extensions wse,

1909: l_stat_num := 20;
1910: select l_sep || wse.sector_extension_code
1911: into l_suffix
1912: from wip_entities we,
1913: wsm_sector_extensions wse,
1914: wsm_item_extensions wie
1915: where we.wip_entity_id = p_wip_entity_id
1916: and we.primary_item_id = wie.inventory_item_id
1917: and we.organization_id = wie.organization_id

Line 1932: from wsm_sector_extensions wse,

1928: -- abb bug 2345650: added the exception block and no-data-found handler.
1929: BEGIN
1930: select l_sep || wse.sector_extension_code
1931: into l_suffix
1932: from wsm_sector_extensions wse,
1933: wsm_subinventory_extensions wsube
1934: where wse.sector_extension_id = wsube.sector_extension_id
1935: and wsube.secondary_inventory_name = l_comp_subinv -- p_subinventory Fix bug #1504009
1936: and wsube.organization_id = p_org_id;