DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on MTL_ITEM_CATEGORIES

Line 1014: FROM MTL_ITEM_CATEGORIES MIC,

1010: x_progress := '004';
1011: BEGIN
1012: SELECT MIC.category_id
1013: INTO x_category_id
1014: FROM MTL_ITEM_CATEGORIES MIC,
1015: MTL_DEFAULT_SETS_VIEW MDSV
1016: WHERE MIC.inventory_item_id = x_item_id
1017: AND MIC.organization_id = x_inv_org_id
1018: AND MIC.category_set_id = MDSV.category_set_id

Line 1054: FROM MTL_ITEM_CATEGORIES MIC,

1050: x_progress := '005';
1051: BEGIN
1052: SELECT distinct 'Y'
1053: INTO x_valid_flag
1054: FROM MTL_ITEM_CATEGORIES MIC,
1055: MTL_DEFAULT_SETS_VIEW MDSV
1056: WHERE MIC.category_id = x_category_id
1057: AND MIC.inventory_item_id = x_item_id
1058: AND MIC.organization_id = x_inv_org_id