APPS.QA_PLAN_ELEMENT_API dependencies on QA_SPECS

Line 221: qa_specs QS

217: QSC.upper_user_defined_limit,
218: QSC.lower_user_defined_limit,
219: QSC.uom_code
220: FROM qa_spec_chars QSC,
221: qa_specs QS
222: WHERE QSC.char_id = e_id
223: AND QSC.spec_id = QS.common_spec_id
224: AND QS.spec_id = s_id;
225:

Line 260: qa_specs QS

256: QSC.upper_user_defined_limit,
257: QSC.lower_user_defined_limit,
258: QSC.uom_code
259: FROM qa_spec_chars QSC,
260: qa_specs QS
261: WHERE QSC.spec_id = QS.common_spec_id
262: AND QS.spec_id = s_id;
263:
264: l_spec_char_rec qa_spec_char_rec;

Line 897: qa_specs qs

893: qsc.UOM_CODE
894:
895: from
896: qa_spec_chars qsc,
897: qa_specs qs
898:
899: where
900: qsc.spec_id = qs.common_spec_id and
901: qs.spec_id = p_spec_id) QscQs

Line 5025: FROM qa_specs

5021: SELECT name
5022: FROM qa_chars
5023: WHERE char_id =
5024: ( SELECT char_id
5025: FROM qa_specs
5026: WHERE spec_id = x_spec_id );
5027:
5028: BEGIN
5029:

Line 5048: FROM qa_specs

5044: FROM mfg_lookups
5045: WHERE lookup_type = 'QA_SPEC_TYPE'
5046: AND lookup_code =
5047: ( SELECT assignment_type
5048: FROM qa_specs
5049: WHERE spec_id = p_spec_id );
5050:
5051: BEGIN
5052:

Line 5065: FROM qa_specs

5061: x_item_name OUT NOCOPY VARCHAR2) IS
5062:
5063: CURSOR c IS
5064: SELECT organization_id, item_id
5065: FROM qa_specs
5066: WHERE spec_id = p_spec_id;
5067:
5068: l_org_id NUMBER;
5069: l_item_id NUMBER;

Line 5090: FROM qa_specs

5086: SELECT vendor_name
5087: FROM po_vendors
5088: WHERE vendor_id =
5089: ( SELECT vendor_id
5090: FROM qa_specs
5091: WHERE spec_id = p_spec_id );
5092:
5093: BEGIN
5094:

Line 5110: FROM qa_specs

5106: SELECT customer_name
5107: FROM qa_customers_lov_v
5108: WHERE customer_id =
5109: ( SELECT customer_id
5110: FROM qa_specs
5111: WHERE spec_id = p_spec_id );
5112:
5113: BEGIN
5114: