DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on MTL_ITEM_CATEGORIES

Line 1060: FROM MTL_ITEM_CATEGORIES MIC,

1056: x_progress := '004';
1057: BEGIN
1058: SELECT MIC.category_id
1059: INTO x_category_id
1060: FROM MTL_ITEM_CATEGORIES MIC,
1061: MTL_DEFAULT_SETS_VIEW MDSV
1062: WHERE MIC.inventory_item_id = x_item_id
1063: AND MIC.organization_id = x_inv_org_id
1064: AND MIC.category_set_id = MDSV.category_set_id

Line 1100: FROM MTL_ITEM_CATEGORIES MIC,

1096: x_progress := '005';
1097: BEGIN
1098: SELECT distinct 'Y'
1099: INTO x_valid_flag
1100: FROM MTL_ITEM_CATEGORIES MIC,
1101: MTL_DEFAULT_SETS_VIEW MDSV
1102: WHERE MIC.category_id = x_category_id
1103: AND MIC.inventory_item_id = x_item_id
1104: AND MIC.organization_id = x_inv_org_id