DBA Data[Home] [Help]

APPS.WSMPUTIL dependencies on WSM_SECTOR_EXTENSIONS

Line 630: FROM WSM_SECTOR_EXTENSIONS WSE,

626:
627: BEGIN
628: SELECT WSE.DEFAULT_ACCT_CLASS_CODE
629: INTO x_accounting_class_code
630: FROM WSM_SECTOR_EXTENSIONS WSE,
631: WSM_ITEM_EXTENSIONS WIE
632: WHERE WIE.organization_id = p_organization_id
633: AND WIE.inventory_item_id = p_inventory_item_id
634: AND WIE.sector_extension_id = WSE.sector_extension_id

Line 650: FROM WSM_SECTOR_EXTENSIONS WSE,

646: BEGIN
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