APPS.CSTPACWF dependencies on MTL_ITEM_CATEGORIES

Line 379: MTL_ITEM_CATEGORIES mic,

375:
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

Line 456: MTL_ITEM_CATEGORIES mic,

452:
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

Line 533: MTL_ITEM_CATEGORIES mic,

529:
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

Line 609: MTL_ITEM_CATEGORIES mic,

605: L_CG_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'CG_ID');
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

Line 686: MTL_ITEM_CATEGORIES mic,

682:
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