DBA Data[Home] [Help]

APPS.CSTPSCWF dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 394: MTL_DEFAULT_CATEGORY_SETS mdcs

390:
391: SELECT nvl(mca.material_account,-1) into L_ACCOUNT
392: FROM MTL_CATEGORY_ACCOUNTS mca,
393: MTL_ITEM_CATEGORIES mic,
394: MTL_DEFAULT_CATEGORY_SETS mdcs
395: WHERE mdcs.functional_area_id = 8
396: AND mdcs.category_set_id = mic.category_set_id
397: AND mca.category_id = mic.category_id
398: AND mca.category_set_id = mic.category_set_id

Line 469: MTL_DEFAULT_CATEGORY_SETS mdcs

465:
466: SELECT nvl(mca.material_overhead_account,-1) into L_ACCOUNT
467: FROM MTL_CATEGORY_ACCOUNTS mca,
468: MTL_ITEM_CATEGORIES mic,
469: MTL_DEFAULT_CATEGORY_SETS mdcs
470: WHERE mdcs.functional_area_id = 8
471: AND mdcs.category_set_id = mic.category_set_id
472: AND mca.category_id = mic.category_id
473: AND mca.category_set_id = mic.category_set_id

Line 546: MTL_DEFAULT_CATEGORY_SETS mdcs

542:
543: SELECT nvl(mca.resource_account,-1) into L_ACCOUNT
544: FROM MTL_CATEGORY_ACCOUNTS mca,
545: MTL_ITEM_CATEGORIES mic,
546: MTL_DEFAULT_CATEGORY_SETS mdcs
547: WHERE mdcs.functional_area_id = 8
548: AND mdcs.category_set_id = mic.category_set_id
549: AND mca.category_id = mic.category_id
550: AND mca.category_set_id = mic.category_set_id

Line 623: MTL_DEFAULT_CATEGORY_SETS mdcs

619:
620: SELECT nvl(mca.outside_processing_account,-1) into L_ACCOUNT
621: FROM MTL_CATEGORY_ACCOUNTS mca,
622: MTL_ITEM_CATEGORIES mic,
623: MTL_DEFAULT_CATEGORY_SETS mdcs
624: WHERE mdcs.functional_area_id = 8
625: AND mdcs.category_set_id = mic.category_set_id
626: AND mca.category_id = mic.category_id
627: AND mca.category_set_id = mic.category_set_id

Line 700: MTL_DEFAULT_CATEGORY_SETS mdcs

696:
697: SELECT nvl(mca.overhead_account,-1) into L_ACCOUNT
698: FROM MTL_CATEGORY_ACCOUNTS mca,
699: MTL_ITEM_CATEGORIES mic,
700: MTL_DEFAULT_CATEGORY_SETS mdcs
701: WHERE mdcs.functional_area_id = 8
702: AND mdcs.category_set_id = mic.category_set_id
703: AND mca.category_id = mic.category_id
704: AND mca.category_set_id = mic.category_set_id