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 4827: FROM qa_specs

4823: SELECT name
4824: FROM qa_chars
4825: WHERE char_id =
4826: ( SELECT char_id
4827: FROM qa_specs
4828: WHERE spec_id = x_spec_id );
4829:
4830: BEGIN
4831:

Line 4850: FROM qa_specs

4846: FROM mfg_lookups
4847: WHERE lookup_type = 'QA_SPEC_TYPE'
4848: AND lookup_code =
4849: ( SELECT assignment_type
4850: FROM qa_specs
4851: WHERE spec_id = p_spec_id );
4852:
4853: BEGIN
4854:

Line 4867: FROM qa_specs

4863: x_item_name OUT NOCOPY VARCHAR2) IS
4864:
4865: CURSOR c IS
4866: SELECT organization_id, item_id
4867: FROM qa_specs
4868: WHERE spec_id = p_spec_id;
4869:
4870: l_org_id NUMBER;
4871: l_item_id NUMBER;

Line 4892: FROM qa_specs

4888: SELECT vendor_name
4889: FROM po_vendors
4890: WHERE vendor_id =
4891: ( SELECT vendor_id
4892: FROM qa_specs
4893: WHERE spec_id = p_spec_id );
4894:
4895: BEGIN
4896:

Line 4912: FROM qa_specs

4908: SELECT customer_name
4909: FROM qa_customers_lov_v
4910: WHERE customer_id =
4911: ( SELECT customer_id
4912: FROM qa_specs
4913: WHERE spec_id = p_spec_id );
4914:
4915: BEGIN
4916: