DBA Data[Home] [Help]

APPS.QA_SAMPLING_PKG dependencies on QA_SAMPLING_RCV_CRITERIA_VAL_V

Line 1058: qa_sampling_rcv_criteria_val_v qsrc

1054: is
1055: select
1056: sampling_plan_id, criteria_id
1057: from
1058: qa_sampling_rcv_criteria_val_v qsrc
1059: where
1060: qsrc.vendor_id in (-1, x_vendor_id) AND
1061: qsrc.vendor_site_id in (-1, x_vendor_site_id) AND
1062: qsrc.item_id in (-1, x_item_id)AND

Line 1089: qa_sampling_rcv_criteria_val_v qsrcvv

1085: x_item_category_id number) IS
1086: SELECT Nvl(micv.category_id,-1) item_category_id
1087: FROM MTL_ITEM_CATEGORIES_V MICV,
1088: QA_SAMPLING_PLANS qsp,
1089: qa_sampling_rcv_criteria_val_v qsrcvv
1090: WHERE micv.inventory_item_id= x_item_id AND
1091: micv.organization_id= x_organization_id AND
1092: qsrcvv.item_category_id = micv.category_id AND
1093: qsp.sampling_plan_id = qsrcvv.sampling_plan_id AND