513: -- component lot number and lot number lovs missing in
514: -- OA Fwk based Quality (iSP, EAM and QWB)
515:
516: IF (p_element_id IN
517: (qa_ss_const.Item,
518: qa_ss_const.Locator,
519: qa_ss_const.Comp_Revision,
520: qa_ss_const.Comp_Subinventory,
521: qa_ss_const.Comp_UOM,
514: -- OA Fwk based Quality (iSP, EAM and QWB)
515:
516: IF (p_element_id IN
517: (qa_ss_const.Item,
518: qa_ss_const.Locator,
519: qa_ss_const.Comp_Revision,
520: qa_ss_const.Comp_Subinventory,
521: qa_ss_const.Comp_UOM,
522: qa_ss_const.Customer_Name,
515:
516: IF (p_element_id IN
517: (qa_ss_const.Item,
518: qa_ss_const.Locator,
519: qa_ss_const.Comp_Revision,
520: qa_ss_const.Comp_Subinventory,
521: qa_ss_const.Comp_UOM,
522: qa_ss_const.Customer_Name,
523: qa_ss_const.Department,
516: IF (p_element_id IN
517: (qa_ss_const.Item,
518: qa_ss_const.Locator,
519: qa_ss_const.Comp_Revision,
520: qa_ss_const.Comp_Subinventory,
521: qa_ss_const.Comp_UOM,
522: qa_ss_const.Customer_Name,
523: qa_ss_const.Department,
524: qa_ss_const.From_Op_Seq_Num,
517: (qa_ss_const.Item,
518: qa_ss_const.Locator,
519: qa_ss_const.Comp_Revision,
520: qa_ss_const.Comp_Subinventory,
521: qa_ss_const.Comp_UOM,
522: qa_ss_const.Customer_Name,
523: qa_ss_const.Department,
524: qa_ss_const.From_Op_Seq_Num,
525: qa_ss_const.Production_Line,
518: qa_ss_const.Locator,
519: qa_ss_const.Comp_Revision,
520: qa_ss_const.Comp_Subinventory,
521: qa_ss_const.Comp_UOM,
522: qa_ss_const.Customer_Name,
523: qa_ss_const.Department,
524: qa_ss_const.From_Op_Seq_Num,
525: qa_ss_const.Production_Line,
526: qa_ss_const.PO_Number,
519: qa_ss_const.Comp_Revision,
520: qa_ss_const.Comp_Subinventory,
521: qa_ss_const.Comp_UOM,
522: qa_ss_const.Customer_Name,
523: qa_ss_const.Department,
524: qa_ss_const.From_Op_Seq_Num,
525: qa_ss_const.Production_Line,
526: qa_ss_const.PO_Number,
527: qa_ss_const.PO_Release_Num,
520: qa_ss_const.Comp_Subinventory,
521: qa_ss_const.Comp_UOM,
522: qa_ss_const.Customer_Name,
523: qa_ss_const.Department,
524: qa_ss_const.From_Op_Seq_Num,
525: qa_ss_const.Production_Line,
526: qa_ss_const.PO_Number,
527: qa_ss_const.PO_Release_Num,
528: qa_ss_const.po_line_num, -- bug 3215866
521: qa_ss_const.Comp_UOM,
522: qa_ss_const.Customer_Name,
523: qa_ss_const.Department,
524: qa_ss_const.From_Op_Seq_Num,
525: qa_ss_const.Production_Line,
526: qa_ss_const.PO_Number,
527: qa_ss_const.PO_Release_Num,
528: qa_ss_const.po_line_num, -- bug 3215866
529: qa_ss_const.PO_Shipment_Num,
522: qa_ss_const.Customer_Name,
523: qa_ss_const.Department,
524: qa_ss_const.From_Op_Seq_Num,
525: qa_ss_const.Production_Line,
526: qa_ss_const.PO_Number,
527: qa_ss_const.PO_Release_Num,
528: qa_ss_const.po_line_num, -- bug 3215866
529: qa_ss_const.PO_Shipment_Num,
530: qa_ss_const.Project_Number,
523: qa_ss_const.Department,
524: qa_ss_const.From_Op_Seq_Num,
525: qa_ss_const.Production_Line,
526: qa_ss_const.PO_Number,
527: qa_ss_const.PO_Release_Num,
528: qa_ss_const.po_line_num, -- bug 3215866
529: qa_ss_const.PO_Shipment_Num,
530: qa_ss_const.Project_Number,
531: qa_ss_const.Receipt_Num,
524: qa_ss_const.From_Op_Seq_Num,
525: qa_ss_const.Production_Line,
526: qa_ss_const.PO_Number,
527: qa_ss_const.PO_Release_Num,
528: qa_ss_const.po_line_num, -- bug 3215866
529: qa_ss_const.PO_Shipment_Num,
530: qa_ss_const.Project_Number,
531: qa_ss_const.Receipt_Num,
532: qa_ss_const.Resource_Code,
525: qa_ss_const.Production_Line,
526: qa_ss_const.PO_Number,
527: qa_ss_const.PO_Release_Num,
528: qa_ss_const.po_line_num, -- bug 3215866
529: qa_ss_const.PO_Shipment_Num,
530: qa_ss_const.Project_Number,
531: qa_ss_const.Receipt_Num,
532: qa_ss_const.Resource_Code,
533: qa_ss_const.Revision,
526: qa_ss_const.PO_Number,
527: qa_ss_const.PO_Release_Num,
528: qa_ss_const.po_line_num, -- bug 3215866
529: qa_ss_const.PO_Shipment_Num,
530: qa_ss_const.Project_Number,
531: qa_ss_const.Receipt_Num,
532: qa_ss_const.Resource_Code,
533: qa_ss_const.Revision,
534: qa_ss_const.RMA_Number,
527: qa_ss_const.PO_Release_Num,
528: qa_ss_const.po_line_num, -- bug 3215866
529: qa_ss_const.PO_Shipment_Num,
530: qa_ss_const.Project_Number,
531: qa_ss_const.Receipt_Num,
532: qa_ss_const.Resource_Code,
533: qa_ss_const.Revision,
534: qa_ss_const.RMA_Number,
535: qa_ss_const.Sales_Order,
528: qa_ss_const.po_line_num, -- bug 3215866
529: qa_ss_const.PO_Shipment_Num,
530: qa_ss_const.Project_Number,
531: qa_ss_const.Receipt_Num,
532: qa_ss_const.Resource_Code,
533: qa_ss_const.Revision,
534: qa_ss_const.RMA_Number,
535: qa_ss_const.Sales_Order,
536: qa_ss_const.Subinventory,
529: qa_ss_const.PO_Shipment_Num,
530: qa_ss_const.Project_Number,
531: qa_ss_const.Receipt_Num,
532: qa_ss_const.Resource_Code,
533: qa_ss_const.Revision,
534: qa_ss_const.RMA_Number,
535: qa_ss_const.Sales_Order,
536: qa_ss_const.Subinventory,
537: qa_ss_const.Task_Number,
530: qa_ss_const.Project_Number,
531: qa_ss_const.Receipt_Num,
532: qa_ss_const.Resource_Code,
533: qa_ss_const.Revision,
534: qa_ss_const.RMA_Number,
535: qa_ss_const.Sales_Order,
536: qa_ss_const.Subinventory,
537: qa_ss_const.Task_Number,
538: qa_ss_const.To_Department,
531: qa_ss_const.Receipt_Num,
532: qa_ss_const.Resource_Code,
533: qa_ss_const.Revision,
534: qa_ss_const.RMA_Number,
535: qa_ss_const.Sales_Order,
536: qa_ss_const.Subinventory,
537: qa_ss_const.Task_Number,
538: qa_ss_const.To_Department,
539: qa_ss_const.To_Op_Seq_Num,
532: qa_ss_const.Resource_Code,
533: qa_ss_const.Revision,
534: qa_ss_const.RMA_Number,
535: qa_ss_const.Sales_Order,
536: qa_ss_const.Subinventory,
537: qa_ss_const.Task_Number,
538: qa_ss_const.To_Department,
539: qa_ss_const.To_Op_Seq_Num,
540: qa_ss_const.UOM,
533: qa_ss_const.Revision,
534: qa_ss_const.RMA_Number,
535: qa_ss_const.Sales_Order,
536: qa_ss_const.Subinventory,
537: qa_ss_const.Task_Number,
538: qa_ss_const.To_Department,
539: qa_ss_const.To_Op_Seq_Num,
540: qa_ss_const.UOM,
541: qa_ss_const.Vendor_Name,
534: qa_ss_const.RMA_Number,
535: qa_ss_const.Sales_Order,
536: qa_ss_const.Subinventory,
537: qa_ss_const.Task_Number,
538: qa_ss_const.To_Department,
539: qa_ss_const.To_Op_Seq_Num,
540: qa_ss_const.UOM,
541: qa_ss_const.Vendor_Name,
542: qa_ss_const.Job_Name,
535: qa_ss_const.Sales_Order,
536: qa_ss_const.Subinventory,
537: qa_ss_const.Task_Number,
538: qa_ss_const.To_Department,
539: qa_ss_const.To_Op_Seq_Num,
540: qa_ss_const.UOM,
541: qa_ss_const.Vendor_Name,
542: qa_ss_const.Job_Name,
543: qa_ss_const.asset_group,
536: qa_ss_const.Subinventory,
537: qa_ss_const.Task_Number,
538: qa_ss_const.To_Department,
539: qa_ss_const.To_Op_Seq_Num,
540: qa_ss_const.UOM,
541: qa_ss_const.Vendor_Name,
542: qa_ss_const.Job_Name,
543: qa_ss_const.asset_group,
544: qa_ss_const.asset_number,
537: qa_ss_const.Task_Number,
538: qa_ss_const.To_Department,
539: qa_ss_const.To_Op_Seq_Num,
540: qa_ss_const.UOM,
541: qa_ss_const.Vendor_Name,
542: qa_ss_const.Job_Name,
543: qa_ss_const.asset_group,
544: qa_ss_const.asset_number,
545: --dgupta: R12 EAM Integration. Bug 4345492 Start
538: qa_ss_const.To_Department,
539: qa_ss_const.To_Op_Seq_Num,
540: qa_ss_const.UOM,
541: qa_ss_const.Vendor_Name,
542: qa_ss_const.Job_Name,
543: qa_ss_const.asset_group,
544: qa_ss_const.asset_number,
545: --dgupta: R12 EAM Integration. Bug 4345492 Start
546: qa_ss_const.asset_instance_number,
539: qa_ss_const.To_Op_Seq_Num,
540: qa_ss_const.UOM,
541: qa_ss_const.Vendor_Name,
542: qa_ss_const.Job_Name,
543: qa_ss_const.asset_group,
544: qa_ss_const.asset_number,
545: --dgupta: R12 EAM Integration. Bug 4345492 Start
546: qa_ss_const.asset_instance_number,
547: --dgupta: R12 EAM Integration. Bug 4345492 End
540: qa_ss_const.UOM,
541: qa_ss_const.Vendor_Name,
542: qa_ss_const.Job_Name,
543: qa_ss_const.asset_group,
544: qa_ss_const.asset_number,
545: --dgupta: R12 EAM Integration. Bug 4345492 Start
546: qa_ss_const.asset_instance_number,
547: --dgupta: R12 EAM Integration. Bug 4345492 End
548: qa_ss_const.asset_activity,
542: qa_ss_const.Job_Name,
543: qa_ss_const.asset_group,
544: qa_ss_const.asset_number,
545: --dgupta: R12 EAM Integration. Bug 4345492 Start
546: qa_ss_const.asset_instance_number,
547: --dgupta: R12 EAM Integration. Bug 4345492 End
548: qa_ss_const.asset_activity,
549: qa_ss_const.work_order,
550: qa_ss_const.maintenance_op_seq,
544: qa_ss_const.asset_number,
545: --dgupta: R12 EAM Integration. Bug 4345492 Start
546: qa_ss_const.asset_instance_number,
547: --dgupta: R12 EAM Integration. Bug 4345492 End
548: qa_ss_const.asset_activity,
549: qa_ss_const.work_order,
550: qa_ss_const.maintenance_op_seq,
551: qa_ss_const.followup_activity,
552: qa_ss_const.comp_item,
545: --dgupta: R12 EAM Integration. Bug 4345492 Start
546: qa_ss_const.asset_instance_number,
547: --dgupta: R12 EAM Integration. Bug 4345492 End
548: qa_ss_const.asset_activity,
549: qa_ss_const.work_order,
550: qa_ss_const.maintenance_op_seq,
551: qa_ss_const.followup_activity,
552: qa_ss_const.comp_item,
553: qa_ss_const.serial_number,
546: qa_ss_const.asset_instance_number,
547: --dgupta: R12 EAM Integration. Bug 4345492 End
548: qa_ss_const.asset_activity,
549: qa_ss_const.work_order,
550: qa_ss_const.maintenance_op_seq,
551: qa_ss_const.followup_activity,
552: qa_ss_const.comp_item,
553: qa_ss_const.serial_number,
554: qa_ss_const.lot_number,
547: --dgupta: R12 EAM Integration. Bug 4345492 End
548: qa_ss_const.asset_activity,
549: qa_ss_const.work_order,
550: qa_ss_const.maintenance_op_seq,
551: qa_ss_const.followup_activity,
552: qa_ss_const.comp_item,
553: qa_ss_const.serial_number,
554: qa_ss_const.lot_number,
555: qa_ss_const.comp_lot_number,
548: qa_ss_const.asset_activity,
549: qa_ss_const.work_order,
550: qa_ss_const.maintenance_op_seq,
551: qa_ss_const.followup_activity,
552: qa_ss_const.comp_item,
553: qa_ss_const.serial_number,
554: qa_ss_const.lot_number,
555: qa_ss_const.comp_lot_number,
556: qa_ss_const.comp_serial_number,
549: qa_ss_const.work_order,
550: qa_ss_const.maintenance_op_seq,
551: qa_ss_const.followup_activity,
552: qa_ss_const.comp_item,
553: qa_ss_const.serial_number,
554: qa_ss_const.lot_number,
555: qa_ss_const.comp_lot_number,
556: qa_ss_const.comp_serial_number,
557: /* R12 DR Integration. Bug 4345489 */
550: qa_ss_const.maintenance_op_seq,
551: qa_ss_const.followup_activity,
552: qa_ss_const.comp_item,
553: qa_ss_const.serial_number,
554: qa_ss_const.lot_number,
555: qa_ss_const.comp_lot_number,
556: qa_ss_const.comp_serial_number,
557: /* R12 DR Integration. Bug 4345489 */
558: qa_ss_const.repair_order_number,
551: qa_ss_const.followup_activity,
552: qa_ss_const.comp_item,
553: qa_ss_const.serial_number,
554: qa_ss_const.lot_number,
555: qa_ss_const.comp_lot_number,
556: qa_ss_const.comp_serial_number,
557: /* R12 DR Integration. Bug 4345489 */
558: qa_ss_const.repair_order_number,
559: qa_ss_const.jtf_task_number,
552: qa_ss_const.comp_item,
553: qa_ss_const.serial_number,
554: qa_ss_const.lot_number,
555: qa_ss_const.comp_lot_number,
556: qa_ss_const.comp_serial_number,
557: /* R12 DR Integration. Bug 4345489 */
558: qa_ss_const.repair_order_number,
559: qa_ss_const.jtf_task_number,
560: /* R12 DR Integration. Bug 4345489 */
554: qa_ss_const.lot_number,
555: qa_ss_const.comp_lot_number,
556: qa_ss_const.comp_serial_number,
557: /* R12 DR Integration. Bug 4345489 */
558: qa_ss_const.repair_order_number,
559: qa_ss_const.jtf_task_number,
560: /* R12 DR Integration. Bug 4345489 */
561: -- R12 OPM Deviations. Bug 4345503 Start
562: qa_ss_const.process_batch_num,
555: qa_ss_const.comp_lot_number,
556: qa_ss_const.comp_serial_number,
557: /* R12 DR Integration. Bug 4345489 */
558: qa_ss_const.repair_order_number,
559: qa_ss_const.jtf_task_number,
560: /* R12 DR Integration. Bug 4345489 */
561: -- R12 OPM Deviations. Bug 4345503 Start
562: qa_ss_const.process_batch_num,
563: qa_ss_const.process_batchstep_num,
558: qa_ss_const.repair_order_number,
559: qa_ss_const.jtf_task_number,
560: /* R12 DR Integration. Bug 4345489 */
561: -- R12 OPM Deviations. Bug 4345503 Start
562: qa_ss_const.process_batch_num,
563: qa_ss_const.process_batchstep_num,
564: qa_ss_const.process_operation,
565: qa_ss_const.process_activity,
566: qa_ss_const.process_resource,
559: qa_ss_const.jtf_task_number,
560: /* R12 DR Integration. Bug 4345489 */
561: -- R12 OPM Deviations. Bug 4345503 Start
562: qa_ss_const.process_batch_num,
563: qa_ss_const.process_batchstep_num,
564: qa_ss_const.process_operation,
565: qa_ss_const.process_activity,
566: qa_ss_const.process_resource,
567: qa_ss_const.process_parameter
560: /* R12 DR Integration. Bug 4345489 */
561: -- R12 OPM Deviations. Bug 4345503 Start
562: qa_ss_const.process_batch_num,
563: qa_ss_const.process_batchstep_num,
564: qa_ss_const.process_operation,
565: qa_ss_const.process_activity,
566: qa_ss_const.process_resource,
567: qa_ss_const.process_parameter
568: -- R12 OPM Deviations. Bug 4345503 End
561: -- R12 OPM Deviations. Bug 4345503 Start
562: qa_ss_const.process_batch_num,
563: qa_ss_const.process_batchstep_num,
564: qa_ss_const.process_operation,
565: qa_ss_const.process_activity,
566: qa_ss_const.process_resource,
567: qa_ss_const.process_parameter
568: -- R12 OPM Deviations. Bug 4345503 End
569: )
562: qa_ss_const.process_batch_num,
563: qa_ss_const.process_batchstep_num,
564: qa_ss_const.process_operation,
565: qa_ss_const.process_activity,
566: qa_ss_const.process_resource,
567: qa_ss_const.process_parameter
568: -- R12 OPM Deviations. Bug 4345503 End
569: )
570: ) THEN
563: qa_ss_const.process_batchstep_num,
564: qa_ss_const.process_operation,
565: qa_ss_const.process_activity,
566: qa_ss_const.process_resource,
567: qa_ss_const.process_parameter
568: -- R12 OPM Deviations. Bug 4345503 End
569: )
570: ) THEN
571: