eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_SS_LOV dependencies on QA_SS_CONST

Line 1241: -- A qa_ss_const.var150_table;

1237: sql_val_str qa_chars.sql_validation_string%TYPE := NULL;
1238: ignore INTEGER;
1239: ORDER_POS NUMBER;
1240: empty_valstring_ex EXCEPTION;
1241: -- A qa_ss_const.var150_table;
1242: -- instead of A table above, use global GV_Elmt_tab better perf
1243: plan_org_ex EXCEPTION;
1244:
1245: /* PAGING VARS */

Line 1516: If (vchar_id = qa_ss_const.Item) Then

1512: End Loop;
1513: */
1514:
1515:
1516: If (vchar_id = qa_ss_const.Item) Then
1517: sql_val_str := Q_Item(plan_id_i, vchar_id, orgz_id);
1518: Elsif (vchar_id = qa_ss_const.Comp_Revision) Then
1519: sql_val_str := Q_Comp_Revision(plan_id_i, vchar_id, orgz_id);
1520: Elsif (vchar_id = qa_ss_const.Comp_Subinventory) Then

Line 1518: Elsif (vchar_id = qa_ss_const.Comp_Revision) Then

1514:
1515:
1516: If (vchar_id = qa_ss_const.Item) Then
1517: sql_val_str := Q_Item(plan_id_i, vchar_id, orgz_id);
1518: Elsif (vchar_id = qa_ss_const.Comp_Revision) Then
1519: sql_val_str := Q_Comp_Revision(plan_id_i, vchar_id, orgz_id);
1520: Elsif (vchar_id = qa_ss_const.Comp_Subinventory) Then
1521: sql_val_str := Q_Comp_Subinventory(plan_id_i, vchar_id, orgz_id);
1522: Elsif (vchar_id = qa_ss_const.Comp_UOM) Then

Line 1520: Elsif (vchar_id = qa_ss_const.Comp_Subinventory) Then

1516: If (vchar_id = qa_ss_const.Item) Then
1517: sql_val_str := Q_Item(plan_id_i, vchar_id, orgz_id);
1518: Elsif (vchar_id = qa_ss_const.Comp_Revision) Then
1519: sql_val_str := Q_Comp_Revision(plan_id_i, vchar_id, orgz_id);
1520: Elsif (vchar_id = qa_ss_const.Comp_Subinventory) Then
1521: sql_val_str := Q_Comp_Subinventory(plan_id_i, vchar_id, orgz_id);
1522: Elsif (vchar_id = qa_ss_const.Comp_UOM) Then
1523: sql_val_str := Q_Comp_Uom(plan_id_i, vchar_id, orgz_id);
1524: Elsif (vchar_id = qa_ss_const.Customer_Name) Then

Line 1522: Elsif (vchar_id = qa_ss_const.Comp_UOM) Then

1518: Elsif (vchar_id = qa_ss_const.Comp_Revision) Then
1519: sql_val_str := Q_Comp_Revision(plan_id_i, vchar_id, orgz_id);
1520: Elsif (vchar_id = qa_ss_const.Comp_Subinventory) Then
1521: sql_val_str := Q_Comp_Subinventory(plan_id_i, vchar_id, orgz_id);
1522: Elsif (vchar_id = qa_ss_const.Comp_UOM) Then
1523: sql_val_str := Q_Comp_Uom(plan_id_i, vchar_id, orgz_id);
1524: Elsif (vchar_id = qa_ss_const.Customer_Name) Then
1525: sql_val_str := Q_Customers(plan_id_i, vchar_id, orgz_id);
1526: Elsif (vchar_id = qa_ss_const.Department) Then

Line 1524: Elsif (vchar_id = qa_ss_const.Customer_Name) Then

1520: Elsif (vchar_id = qa_ss_const.Comp_Subinventory) Then
1521: sql_val_str := Q_Comp_Subinventory(plan_id_i, vchar_id, orgz_id);
1522: Elsif (vchar_id = qa_ss_const.Comp_UOM) Then
1523: sql_val_str := Q_Comp_Uom(plan_id_i, vchar_id, orgz_id);
1524: Elsif (vchar_id = qa_ss_const.Customer_Name) Then
1525: sql_val_str := Q_Customers(plan_id_i, vchar_id, orgz_id);
1526: Elsif (vchar_id = qa_ss_const.Department) Then
1527: sql_val_str := Q_Department(plan_id_i, vchar_id, orgz_id);
1528: Elsif (vchar_id = qa_ss_const.From_Op_Seq_Num) Then

Line 1526: Elsif (vchar_id = qa_ss_const.Department) Then

1522: Elsif (vchar_id = qa_ss_const.Comp_UOM) Then
1523: sql_val_str := Q_Comp_Uom(plan_id_i, vchar_id, orgz_id);
1524: Elsif (vchar_id = qa_ss_const.Customer_Name) Then
1525: sql_val_str := Q_Customers(plan_id_i, vchar_id, orgz_id);
1526: Elsif (vchar_id = qa_ss_const.Department) Then
1527: sql_val_str := Q_Department(plan_id_i, vchar_id, orgz_id);
1528: Elsif (vchar_id = qa_ss_const.From_Op_Seq_Num) Then
1529: sql_val_str := Q_From_Op_Seq_Num(plan_id_i, vchar_id, orgz_id);
1530: Elsif (vchar_id = qa_ss_const.Production_Line) Then

Line 1528: Elsif (vchar_id = qa_ss_const.From_Op_Seq_Num) Then

1524: Elsif (vchar_id = qa_ss_const.Customer_Name) Then
1525: sql_val_str := Q_Customers(plan_id_i, vchar_id, orgz_id);
1526: Elsif (vchar_id = qa_ss_const.Department) Then
1527: sql_val_str := Q_Department(plan_id_i, vchar_id, orgz_id);
1528: Elsif (vchar_id = qa_ss_const.From_Op_Seq_Num) Then
1529: sql_val_str := Q_From_Op_Seq_Num(plan_id_i, vchar_id, orgz_id);
1530: Elsif (vchar_id = qa_ss_const.Production_Line) Then
1531: sql_val_str := Q_Line(plan_id_i, vchar_id, orgz_id);
1532: Elsif (vchar_id = qa_ss_const.Po_Number) Then

Line 1530: Elsif (vchar_id = qa_ss_const.Production_Line) Then

1526: Elsif (vchar_id = qa_ss_const.Department) Then
1527: sql_val_str := Q_Department(plan_id_i, vchar_id, orgz_id);
1528: Elsif (vchar_id = qa_ss_const.From_Op_Seq_Num) Then
1529: sql_val_str := Q_From_Op_Seq_Num(plan_id_i, vchar_id, orgz_id);
1530: Elsif (vchar_id = qa_ss_const.Production_Line) Then
1531: sql_val_str := Q_Line(plan_id_i, vchar_id, orgz_id);
1532: Elsif (vchar_id = qa_ss_const.Po_Number) Then
1533: sql_val_str := Q_Po_Headers(plan_id_i, vchar_id, orgz_id);
1534: Elsif (vchar_id = qa_ss_const.Po_Line_Num) Then

Line 1532: Elsif (vchar_id = qa_ss_const.Po_Number) Then

1528: Elsif (vchar_id = qa_ss_const.From_Op_Seq_Num) Then
1529: sql_val_str := Q_From_Op_Seq_Num(plan_id_i, vchar_id, orgz_id);
1530: Elsif (vchar_id = qa_ss_const.Production_Line) Then
1531: sql_val_str := Q_Line(plan_id_i, vchar_id, orgz_id);
1532: Elsif (vchar_id = qa_ss_const.Po_Number) Then
1533: sql_val_str := Q_Po_Headers(plan_id_i, vchar_id, orgz_id);
1534: Elsif (vchar_id = qa_ss_const.Po_Line_Num) Then
1535: sql_val_str := Q_Po_Lines(plan_id_i, vchar_id, orgz_id);
1536: Elsif (vchar_id = qa_ss_const.Po_Release_Num) Then

Line 1534: Elsif (vchar_id = qa_ss_const.Po_Line_Num) Then

1530: Elsif (vchar_id = qa_ss_const.Production_Line) Then
1531: sql_val_str := Q_Line(plan_id_i, vchar_id, orgz_id);
1532: Elsif (vchar_id = qa_ss_const.Po_Number) Then
1533: sql_val_str := Q_Po_Headers(plan_id_i, vchar_id, orgz_id);
1534: Elsif (vchar_id = qa_ss_const.Po_Line_Num) Then
1535: sql_val_str := Q_Po_Lines(plan_id_i, vchar_id, orgz_id);
1536: Elsif (vchar_id = qa_ss_const.Po_Release_Num) Then
1537: sql_val_str := Q_Po_Release_Nums(plan_id_i, vchar_id, orgz_id);
1538: Elsif (vchar_id = qa_ss_const.Po_Shipment_Num) Then

Line 1536: Elsif (vchar_id = qa_ss_const.Po_Release_Num) Then

1532: Elsif (vchar_id = qa_ss_const.Po_Number) Then
1533: sql_val_str := Q_Po_Headers(plan_id_i, vchar_id, orgz_id);
1534: Elsif (vchar_id = qa_ss_const.Po_Line_Num) Then
1535: sql_val_str := Q_Po_Lines(plan_id_i, vchar_id, orgz_id);
1536: Elsif (vchar_id = qa_ss_const.Po_Release_Num) Then
1537: sql_val_str := Q_Po_Release_Nums(plan_id_i, vchar_id, orgz_id);
1538: Elsif (vchar_id = qa_ss_const.Po_Shipment_Num) Then
1539: sql_val_str := Q_Po_Shipments(plan_id_i, vchar_id, orgz_id);
1540: Elsif (vchar_id = qa_ss_const.Project_Number) Then

Line 1538: Elsif (vchar_id = qa_ss_const.Po_Shipment_Num) Then

1534: Elsif (vchar_id = qa_ss_const.Po_Line_Num) Then
1535: sql_val_str := Q_Po_Lines(plan_id_i, vchar_id, orgz_id);
1536: Elsif (vchar_id = qa_ss_const.Po_Release_Num) Then
1537: sql_val_str := Q_Po_Release_Nums(plan_id_i, vchar_id, orgz_id);
1538: Elsif (vchar_id = qa_ss_const.Po_Shipment_Num) Then
1539: sql_val_str := Q_Po_Shipments(plan_id_i, vchar_id, orgz_id);
1540: Elsif (vchar_id = qa_ss_const.Project_Number) Then
1541: sql_val_str := Q_Project(plan_id_i, vchar_id, orgz_id);
1542: Elsif (vchar_id = qa_ss_const.Receipt_Num) Then

Line 1540: Elsif (vchar_id = qa_ss_const.Project_Number) Then

1536: Elsif (vchar_id = qa_ss_const.Po_Release_Num) Then
1537: sql_val_str := Q_Po_Release_Nums(plan_id_i, vchar_id, orgz_id);
1538: Elsif (vchar_id = qa_ss_const.Po_Shipment_Num) Then
1539: sql_val_str := Q_Po_Shipments(plan_id_i, vchar_id, orgz_id);
1540: Elsif (vchar_id = qa_ss_const.Project_Number) Then
1541: sql_val_str := Q_Project(plan_id_i, vchar_id, orgz_id);
1542: Elsif (vchar_id = qa_ss_const.Receipt_Num) Then
1543: sql_val_str := Q_Receipt_Nums(plan_id_i, vchar_id, orgz_id);
1544: Elsif (vchar_id = qa_ss_const.Resource_Code) Then

Line 1542: Elsif (vchar_id = qa_ss_const.Receipt_Num) Then

1538: Elsif (vchar_id = qa_ss_const.Po_Shipment_Num) Then
1539: sql_val_str := Q_Po_Shipments(plan_id_i, vchar_id, orgz_id);
1540: Elsif (vchar_id = qa_ss_const.Project_Number) Then
1541: sql_val_str := Q_Project(plan_id_i, vchar_id, orgz_id);
1542: Elsif (vchar_id = qa_ss_const.Receipt_Num) Then
1543: sql_val_str := Q_Receipt_Nums(plan_id_i, vchar_id, orgz_id);
1544: Elsif (vchar_id = qa_ss_const.Resource_Code) Then
1545: sql_val_str := Q_Resource(plan_id_i, vchar_id, orgz_id);
1546: Elsif (vchar_id = qa_ss_const.Revision) Then

Line 1544: Elsif (vchar_id = qa_ss_const.Resource_Code) Then

1540: Elsif (vchar_id = qa_ss_const.Project_Number) Then
1541: sql_val_str := Q_Project(plan_id_i, vchar_id, orgz_id);
1542: Elsif (vchar_id = qa_ss_const.Receipt_Num) Then
1543: sql_val_str := Q_Receipt_Nums(plan_id_i, vchar_id, orgz_id);
1544: Elsif (vchar_id = qa_ss_const.Resource_Code) Then
1545: sql_val_str := Q_Resource(plan_id_i, vchar_id, orgz_id);
1546: Elsif (vchar_id = qa_ss_const.Revision) Then
1547: sql_val_str := Q_Revision(plan_id_i, vchar_id, orgz_id);
1548: Elsif (vchar_id = qa_ss_const.RMA_Number) Then

Line 1546: Elsif (vchar_id = qa_ss_const.Revision) Then

1542: Elsif (vchar_id = qa_ss_const.Receipt_Num) Then
1543: sql_val_str := Q_Receipt_Nums(plan_id_i, vchar_id, orgz_id);
1544: Elsif (vchar_id = qa_ss_const.Resource_Code) Then
1545: sql_val_str := Q_Resource(plan_id_i, vchar_id, orgz_id);
1546: Elsif (vchar_id = qa_ss_const.Revision) Then
1547: sql_val_str := Q_Revision(plan_id_i, vchar_id, orgz_id);
1548: Elsif (vchar_id = qa_ss_const.RMA_Number) Then
1549: sql_val_str := Q_Rma_Number(plan_id_i, vchar_id, orgz_id);
1550: Elsif (vchar_id = qa_ss_const.Sales_Order) Then

Line 1548: Elsif (vchar_id = qa_ss_const.RMA_Number) Then

1544: Elsif (vchar_id = qa_ss_const.Resource_Code) Then
1545: sql_val_str := Q_Resource(plan_id_i, vchar_id, orgz_id);
1546: Elsif (vchar_id = qa_ss_const.Revision) Then
1547: sql_val_str := Q_Revision(plan_id_i, vchar_id, orgz_id);
1548: Elsif (vchar_id = qa_ss_const.RMA_Number) Then
1549: sql_val_str := Q_Rma_Number(plan_id_i, vchar_id, orgz_id);
1550: Elsif (vchar_id = qa_ss_const.Sales_Order) Then
1551: sql_val_str := Q_Sales_Orders(plan_id_i, vchar_id, orgz_id);
1552: Elsif (vchar_id = qa_ss_const.Subinventory) Then

Line 1550: Elsif (vchar_id = qa_ss_const.Sales_Order) Then

1546: Elsif (vchar_id = qa_ss_const.Revision) Then
1547: sql_val_str := Q_Revision(plan_id_i, vchar_id, orgz_id);
1548: Elsif (vchar_id = qa_ss_const.RMA_Number) Then
1549: sql_val_str := Q_Rma_Number(plan_id_i, vchar_id, orgz_id);
1550: Elsif (vchar_id = qa_ss_const.Sales_Order) Then
1551: sql_val_str := Q_Sales_Orders(plan_id_i, vchar_id, orgz_id);
1552: Elsif (vchar_id = qa_ss_const.Subinventory) Then
1553: sql_val_str := Q_Subinventory(plan_id_i, vchar_id, orgz_id);
1554: Elsif (vchar_id = qa_ss_const.To_op_seq_num) Then

Line 1552: Elsif (vchar_id = qa_ss_const.Subinventory) Then

1548: Elsif (vchar_id = qa_ss_const.RMA_Number) Then
1549: sql_val_str := Q_Rma_Number(plan_id_i, vchar_id, orgz_id);
1550: Elsif (vchar_id = qa_ss_const.Sales_Order) Then
1551: sql_val_str := Q_Sales_Orders(plan_id_i, vchar_id, orgz_id);
1552: Elsif (vchar_id = qa_ss_const.Subinventory) Then
1553: sql_val_str := Q_Subinventory(plan_id_i, vchar_id, orgz_id);
1554: Elsif (vchar_id = qa_ss_const.To_op_seq_num) Then
1555: sql_val_str := Q_To_Op_Seq_Num(plan_id_i, vchar_id, orgz_id);
1556: Elsif (vchar_id = qa_ss_const.UOM) Then

Line 1554: Elsif (vchar_id = qa_ss_const.To_op_seq_num) Then

1550: Elsif (vchar_id = qa_ss_const.Sales_Order) Then
1551: sql_val_str := Q_Sales_Orders(plan_id_i, vchar_id, orgz_id);
1552: Elsif (vchar_id = qa_ss_const.Subinventory) Then
1553: sql_val_str := Q_Subinventory(plan_id_i, vchar_id, orgz_id);
1554: Elsif (vchar_id = qa_ss_const.To_op_seq_num) Then
1555: sql_val_str := Q_To_Op_Seq_Num(plan_id_i, vchar_id, orgz_id);
1556: Elsif (vchar_id = qa_ss_const.UOM) Then
1557: sql_val_str := Q_UOM(plan_id_i, vchar_id, orgz_id);
1558: Elsif (vchar_id = qa_ss_const.Vendor_Name) Then

Line 1556: Elsif (vchar_id = qa_ss_const.UOM) Then

1552: Elsif (vchar_id = qa_ss_const.Subinventory) Then
1553: sql_val_str := Q_Subinventory(plan_id_i, vchar_id, orgz_id);
1554: Elsif (vchar_id = qa_ss_const.To_op_seq_num) Then
1555: sql_val_str := Q_To_Op_Seq_Num(plan_id_i, vchar_id, orgz_id);
1556: Elsif (vchar_id = qa_ss_const.UOM) Then
1557: sql_val_str := Q_UOM(plan_id_i, vchar_id, orgz_id);
1558: Elsif (vchar_id = qa_ss_const.Vendor_Name) Then
1559: sql_val_str := Q_Vendors(plan_id_i, vchar_id, orgz_id);
1560: Elsif (vchar_id = qa_ss_const.Job_Name) Then

Line 1558: Elsif (vchar_id = qa_ss_const.Vendor_Name) Then

1554: Elsif (vchar_id = qa_ss_const.To_op_seq_num) Then
1555: sql_val_str := Q_To_Op_Seq_Num(plan_id_i, vchar_id, orgz_id);
1556: Elsif (vchar_id = qa_ss_const.UOM) Then
1557: sql_val_str := Q_UOM(plan_id_i, vchar_id, orgz_id);
1558: Elsif (vchar_id = qa_ss_const.Vendor_Name) Then
1559: sql_val_str := Q_Vendors(plan_id_i, vchar_id, orgz_id);
1560: Elsif (vchar_id = qa_ss_const.Job_Name) Then
1561: sql_val_str := Q_Job(plan_id_i, vchar_id, orgz_id);
1562: Elsif (vchar_id = qa_ss_const.Task_Number) Then

Line 1560: Elsif (vchar_id = qa_ss_const.Job_Name) Then

1556: Elsif (vchar_id = qa_ss_const.UOM) Then
1557: sql_val_str := Q_UOM(plan_id_i, vchar_id, orgz_id);
1558: Elsif (vchar_id = qa_ss_const.Vendor_Name) Then
1559: sql_val_str := Q_Vendors(plan_id_i, vchar_id, orgz_id);
1560: Elsif (vchar_id = qa_ss_const.Job_Name) Then
1561: sql_val_str := Q_Job(plan_id_i, vchar_id, orgz_id);
1562: Elsif (vchar_id = qa_ss_const.Task_Number) Then
1563: sql_val_str := Q_Task(plan_id_i, vchar_id, orgz_id);
1564:

Line 1562: Elsif (vchar_id = qa_ss_const.Task_Number) Then

1558: Elsif (vchar_id = qa_ss_const.Vendor_Name) Then
1559: sql_val_str := Q_Vendors(plan_id_i, vchar_id, orgz_id);
1560: Elsif (vchar_id = qa_ss_const.Job_Name) Then
1561: sql_val_str := Q_Job(plan_id_i, vchar_id, orgz_id);
1562: Elsif (vchar_id = qa_ss_const.Task_Number) Then
1563: sql_val_str := Q_Task(plan_id_i, vchar_id, orgz_id);
1564:
1565: End If;
1566:

Line 1783: if (charid in (qa_ss_const.Item,

1779: then
1780: return -1;
1781: end if;
1782:
1783: if (charid in (qa_ss_const.Item,
1784: qa_ss_const.job_name,
1785: qa_ss_const.production_line,
1786: qa_ss_const.po_number,
1787: qa_ss_const.project_number,

Line 1784: qa_ss_const.job_name,

1780: return -1;
1781: end if;
1782:
1783: if (charid in (qa_ss_const.Item,
1784: qa_ss_const.job_name,
1785: qa_ss_const.production_line,
1786: qa_ss_const.po_number,
1787: qa_ss_const.project_number,
1788: qa_ss_const.item,

Line 1785: qa_ss_const.production_line,

1781: end if;
1782:
1783: if (charid in (qa_ss_const.Item,
1784: qa_ss_const.job_name,
1785: qa_ss_const.production_line,
1786: qa_ss_const.po_number,
1787: qa_ss_const.project_number,
1788: qa_ss_const.item,
1789: qa_ss_const.comp_item) )

Line 1786: qa_ss_const.po_number,

1782:
1783: if (charid in (qa_ss_const.Item,
1784: qa_ss_const.job_name,
1785: qa_ss_const.production_line,
1786: qa_ss_const.po_number,
1787: qa_ss_const.project_number,
1788: qa_ss_const.item,
1789: qa_ss_const.comp_item) )
1790: THEN

Line 1787: qa_ss_const.project_number,

1783: if (charid in (qa_ss_const.Item,
1784: qa_ss_const.job_name,
1785: qa_ss_const.production_line,
1786: qa_ss_const.po_number,
1787: qa_ss_const.project_number,
1788: qa_ss_const.item,
1789: qa_ss_const.comp_item) )
1790: THEN
1791: select qc.fk_table_name, qc.pk_id, qc.fk_meaning

Line 1788: qa_ss_const.item,

1784: qa_ss_const.job_name,
1785: qa_ss_const.production_line,
1786: qa_ss_const.po_number,
1787: qa_ss_const.project_number,
1788: qa_ss_const.item,
1789: qa_ss_const.comp_item) )
1790: THEN
1791: select qc.fk_table_name, qc.pk_id, qc.fk_meaning
1792: INTO x_fk_table_name, x_pk_id, x_fk_meaning

Line 1789: qa_ss_const.comp_item) )

1785: qa_ss_const.production_line,
1786: qa_ss_const.po_number,
1787: qa_ss_const.project_number,
1788: qa_ss_const.item,
1789: qa_ss_const.comp_item) )
1790: THEN
1791: select qc.fk_table_name, qc.pk_id, qc.fk_meaning
1792: INTO x_fk_table_name, x_pk_id, x_fk_meaning
1793: FROM qa_chars qc