DBA Data[Home] [Help]

APPS.CSTPSCWF dependencies on MTL_ITEM_CATEGORIES

Line 393: MTL_ITEM_CATEGORIES mic,

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
397: AND mca.category_id = mic.category_id

Line 468: MTL_ITEM_CATEGORIES mic,

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
472: AND mca.category_id = mic.category_id

Line 545: MTL_ITEM_CATEGORIES mic,

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
549: AND mca.category_id = mic.category_id

Line 622: MTL_ITEM_CATEGORIES mic,

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
626: AND mca.category_id = mic.category_id

Line 699: MTL_ITEM_CATEGORIES mic,

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
703: AND mca.category_id = mic.category_id