APPS.CSTPACWF dependencies on MTL_CATEGORY_ACCOUNTS

Line 378: FROM MTL_CATEGORY_ACCOUNTS mca,

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

Line 455: FROM MTL_CATEGORY_ACCOUNTS mca,

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

Line 532: FROM MTL_CATEGORY_ACCOUNTS mca,

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

Line 608: FROM MTL_CATEGORY_ACCOUNTS mca,

604: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
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

Line 685: FROM MTL_CATEGORY_ACCOUNTS mca,

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