APPS.CSTPACWF dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 380: MTL_DEFAULT_CATEGORY_SETS mdcs

376:
377: SELECT nvl(mca.material_account,-1) into L_ACCOUNT
378: FROM MTL_CATEGORY_ACCOUNTS mca,
379: MTL_ITEM_CATEGORIES mic,
380: MTL_DEFAULT_CATEGORY_SETS mdcs
381: WHERE mdcs.functional_area_id = 8
382: AND mdcs.category_set_id = mic.category_set_id
383: AND mca.category_id = mic.category_id
384: AND mca.category_set_id = mic.category_set_id

Line 457: MTL_DEFAULT_CATEGORY_SETS mdcs

453:
454: SELECT nvl(mca.material_overhead_account,-1) into L_ACCOUNT
455: FROM MTL_CATEGORY_ACCOUNTS mca,
456: MTL_ITEM_CATEGORIES mic,
457: MTL_DEFAULT_CATEGORY_SETS mdcs
458: WHERE mdcs.functional_area_id = 8
459: AND mdcs.category_set_id = mic.category_set_id
460: AND mca.category_id = mic.category_id
461: AND mca.category_set_id = mic.category_set_id

Line 534: MTL_DEFAULT_CATEGORY_SETS mdcs

530:
531: SELECT nvl(mca.resource_account,-1) into L_ACCOUNT
532: FROM MTL_CATEGORY_ACCOUNTS mca,
533: MTL_ITEM_CATEGORIES mic,
534: MTL_DEFAULT_CATEGORY_SETS mdcs
535: WHERE mdcs.functional_area_id = 8
536: AND mdcs.category_set_id = mic.category_set_id
537: AND mca.category_id = mic.category_id
538: AND mca.category_set_id = mic.category_set_id

Line 610: MTL_DEFAULT_CATEGORY_SETS mdcs

606:
607: SELECT nvl(mca.outside_processing_account,-1) into L_ACCOUNT
608: FROM MTL_CATEGORY_ACCOUNTS mca,
609: MTL_ITEM_CATEGORIES mic,
610: MTL_DEFAULT_CATEGORY_SETS mdcs
611: WHERE mdcs.functional_area_id = 8
612: AND mdcs.category_set_id = mic.category_set_id
613: AND mca.category_id = mic.category_id
614: AND mca.category_set_id = mic.category_set_id

Line 687: MTL_DEFAULT_CATEGORY_SETS mdcs

683:
684: SELECT nvl(mca.overhead_account,-1) into L_ACCOUNT
685: FROM MTL_CATEGORY_ACCOUNTS mca,
686: MTL_ITEM_CATEGORIES mic,
687: MTL_DEFAULT_CATEGORY_SETS mdcs
688: WHERE mdcs.functional_area_id = 8
689: AND mdcs.category_set_id = mic.category_set_id
690: AND mca.category_id = mic.category_id
691: AND mca.category_set_id = mic.category_set_id