APPS.CSTPSCWF dependencies on MTL_CATEGORY_ACCOUNTS

Line 392: FROM MTL_CATEGORY_ACCOUNTS mca,

388: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
389: L_SUBINV := wf_engine.GetItemAttrText(itemtype,itemkey,'SUBINV');
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

Line 467: FROM MTL_CATEGORY_ACCOUNTS mca,

463: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
464: L_SUBINV := wf_engine.GetItemAttrText(itemtype,itemkey,'SUBINV');
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

Line 544: FROM MTL_CATEGORY_ACCOUNTS mca,

540: L_ITEM_ID := wf_engine.GetItemAttrNumber(itemtype,itemkey,'ITEM_ID');
541: L_SUBINV := wf_engine.GetItemAttrText(itemtype,itemkey,'SUBINV');
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

Line 621: FROM MTL_CATEGORY_ACCOUNTS mca,

617: L_SUBINV := wf_engine.GetItemAttrText(itemtype,itemkey,'SUBINV');
618:
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

Line 698: FROM MTL_CATEGORY_ACCOUNTS mca,

694: L_SUBINV := wf_engine.GetItemAttrText(itemtype,itemkey,'SUBINV');
695:
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