549: -- component lot number and lot number lovs missing in
550: -- OA Fwk based Quality (iSP, EAM and QWB)
551:
552: IF (p_element_id IN
553: (qa_ss_const.Item,
554: qa_ss_const.Locator,
555: qa_ss_const.Comp_Revision,
556: qa_ss_const.Comp_Subinventory,
557: qa_ss_const.Comp_UOM,
550: -- OA Fwk based Quality (iSP, EAM and QWB)
551:
552: IF (p_element_id IN
553: (qa_ss_const.Item,
554: qa_ss_const.Locator,
555: qa_ss_const.Comp_Revision,
556: qa_ss_const.Comp_Subinventory,
557: qa_ss_const.Comp_UOM,
558: qa_ss_const.Customer_Name,
551:
552: IF (p_element_id IN
553: (qa_ss_const.Item,
554: qa_ss_const.Locator,
555: qa_ss_const.Comp_Revision,
556: qa_ss_const.Comp_Subinventory,
557: qa_ss_const.Comp_UOM,
558: qa_ss_const.Customer_Name,
559: qa_ss_const.Department,
552: IF (p_element_id IN
553: (qa_ss_const.Item,
554: qa_ss_const.Locator,
555: qa_ss_const.Comp_Revision,
556: qa_ss_const.Comp_Subinventory,
557: qa_ss_const.Comp_UOM,
558: qa_ss_const.Customer_Name,
559: qa_ss_const.Department,
560: qa_ss_const.From_Op_Seq_Num,
553: (qa_ss_const.Item,
554: qa_ss_const.Locator,
555: qa_ss_const.Comp_Revision,
556: qa_ss_const.Comp_Subinventory,
557: qa_ss_const.Comp_UOM,
558: qa_ss_const.Customer_Name,
559: qa_ss_const.Department,
560: qa_ss_const.From_Op_Seq_Num,
561: qa_ss_const.Production_Line,
554: qa_ss_const.Locator,
555: qa_ss_const.Comp_Revision,
556: qa_ss_const.Comp_Subinventory,
557: qa_ss_const.Comp_UOM,
558: qa_ss_const.Customer_Name,
559: qa_ss_const.Department,
560: qa_ss_const.From_Op_Seq_Num,
561: qa_ss_const.Production_Line,
562: qa_ss_const.PO_Number,
555: qa_ss_const.Comp_Revision,
556: qa_ss_const.Comp_Subinventory,
557: qa_ss_const.Comp_UOM,
558: qa_ss_const.Customer_Name,
559: qa_ss_const.Department,
560: qa_ss_const.From_Op_Seq_Num,
561: qa_ss_const.Production_Line,
562: qa_ss_const.PO_Number,
563: qa_ss_const.PO_Release_Num,
556: qa_ss_const.Comp_Subinventory,
557: qa_ss_const.Comp_UOM,
558: qa_ss_const.Customer_Name,
559: qa_ss_const.Department,
560: qa_ss_const.From_Op_Seq_Num,
561: qa_ss_const.Production_Line,
562: qa_ss_const.PO_Number,
563: qa_ss_const.PO_Release_Num,
564: qa_ss_const.po_line_num, -- bug 3215866
557: qa_ss_const.Comp_UOM,
558: qa_ss_const.Customer_Name,
559: qa_ss_const.Department,
560: qa_ss_const.From_Op_Seq_Num,
561: qa_ss_const.Production_Line,
562: qa_ss_const.PO_Number,
563: qa_ss_const.PO_Release_Num,
564: qa_ss_const.po_line_num, -- bug 3215866
565: qa_ss_const.PO_Shipment_Num,
558: qa_ss_const.Customer_Name,
559: qa_ss_const.Department,
560: qa_ss_const.From_Op_Seq_Num,
561: qa_ss_const.Production_Line,
562: qa_ss_const.PO_Number,
563: qa_ss_const.PO_Release_Num,
564: qa_ss_const.po_line_num, -- bug 3215866
565: qa_ss_const.PO_Shipment_Num,
566: qa_ss_const.Project_Number,
559: qa_ss_const.Department,
560: qa_ss_const.From_Op_Seq_Num,
561: qa_ss_const.Production_Line,
562: qa_ss_const.PO_Number,
563: qa_ss_const.PO_Release_Num,
564: qa_ss_const.po_line_num, -- bug 3215866
565: qa_ss_const.PO_Shipment_Num,
566: qa_ss_const.Project_Number,
567: qa_ss_const.Receipt_Num,
560: qa_ss_const.From_Op_Seq_Num,
561: qa_ss_const.Production_Line,
562: qa_ss_const.PO_Number,
563: qa_ss_const.PO_Release_Num,
564: qa_ss_const.po_line_num, -- bug 3215866
565: qa_ss_const.PO_Shipment_Num,
566: qa_ss_const.Project_Number,
567: qa_ss_const.Receipt_Num,
568: qa_ss_const.Resource_Code,
561: qa_ss_const.Production_Line,
562: qa_ss_const.PO_Number,
563: qa_ss_const.PO_Release_Num,
564: qa_ss_const.po_line_num, -- bug 3215866
565: qa_ss_const.PO_Shipment_Num,
566: qa_ss_const.Project_Number,
567: qa_ss_const.Receipt_Num,
568: qa_ss_const.Resource_Code,
569: qa_ss_const.Revision,
562: qa_ss_const.PO_Number,
563: qa_ss_const.PO_Release_Num,
564: qa_ss_const.po_line_num, -- bug 3215866
565: qa_ss_const.PO_Shipment_Num,
566: qa_ss_const.Project_Number,
567: qa_ss_const.Receipt_Num,
568: qa_ss_const.Resource_Code,
569: qa_ss_const.Revision,
570: qa_ss_const.RMA_Number,
563: qa_ss_const.PO_Release_Num,
564: qa_ss_const.po_line_num, -- bug 3215866
565: qa_ss_const.PO_Shipment_Num,
566: qa_ss_const.Project_Number,
567: qa_ss_const.Receipt_Num,
568: qa_ss_const.Resource_Code,
569: qa_ss_const.Revision,
570: qa_ss_const.RMA_Number,
571: qa_ss_const.Sales_Order,
564: qa_ss_const.po_line_num, -- bug 3215866
565: qa_ss_const.PO_Shipment_Num,
566: qa_ss_const.Project_Number,
567: qa_ss_const.Receipt_Num,
568: qa_ss_const.Resource_Code,
569: qa_ss_const.Revision,
570: qa_ss_const.RMA_Number,
571: qa_ss_const.Sales_Order,
572: qa_ss_const.Subinventory,
565: qa_ss_const.PO_Shipment_Num,
566: qa_ss_const.Project_Number,
567: qa_ss_const.Receipt_Num,
568: qa_ss_const.Resource_Code,
569: qa_ss_const.Revision,
570: qa_ss_const.RMA_Number,
571: qa_ss_const.Sales_Order,
572: qa_ss_const.Subinventory,
573: qa_ss_const.Task_Number,
566: qa_ss_const.Project_Number,
567: qa_ss_const.Receipt_Num,
568: qa_ss_const.Resource_Code,
569: qa_ss_const.Revision,
570: qa_ss_const.RMA_Number,
571: qa_ss_const.Sales_Order,
572: qa_ss_const.Subinventory,
573: qa_ss_const.Task_Number,
574: qa_ss_const.To_Department,
567: qa_ss_const.Receipt_Num,
568: qa_ss_const.Resource_Code,
569: qa_ss_const.Revision,
570: qa_ss_const.RMA_Number,
571: qa_ss_const.Sales_Order,
572: qa_ss_const.Subinventory,
573: qa_ss_const.Task_Number,
574: qa_ss_const.To_Department,
575: qa_ss_const.To_Op_Seq_Num,
568: qa_ss_const.Resource_Code,
569: qa_ss_const.Revision,
570: qa_ss_const.RMA_Number,
571: qa_ss_const.Sales_Order,
572: qa_ss_const.Subinventory,
573: qa_ss_const.Task_Number,
574: qa_ss_const.To_Department,
575: qa_ss_const.To_Op_Seq_Num,
576: qa_ss_const.UOM,
569: qa_ss_const.Revision,
570: qa_ss_const.RMA_Number,
571: qa_ss_const.Sales_Order,
572: qa_ss_const.Subinventory,
573: qa_ss_const.Task_Number,
574: qa_ss_const.To_Department,
575: qa_ss_const.To_Op_Seq_Num,
576: qa_ss_const.UOM,
577: qa_ss_const.Vendor_Name,
570: qa_ss_const.RMA_Number,
571: qa_ss_const.Sales_Order,
572: qa_ss_const.Subinventory,
573: qa_ss_const.Task_Number,
574: qa_ss_const.To_Department,
575: qa_ss_const.To_Op_Seq_Num,
576: qa_ss_const.UOM,
577: qa_ss_const.Vendor_Name,
578: qa_ss_const.Job_Name,
571: qa_ss_const.Sales_Order,
572: qa_ss_const.Subinventory,
573: qa_ss_const.Task_Number,
574: qa_ss_const.To_Department,
575: qa_ss_const.To_Op_Seq_Num,
576: qa_ss_const.UOM,
577: qa_ss_const.Vendor_Name,
578: qa_ss_const.Job_Name,
579: qa_ss_const.asset_group,
572: qa_ss_const.Subinventory,
573: qa_ss_const.Task_Number,
574: qa_ss_const.To_Department,
575: qa_ss_const.To_Op_Seq_Num,
576: qa_ss_const.UOM,
577: qa_ss_const.Vendor_Name,
578: qa_ss_const.Job_Name,
579: qa_ss_const.asset_group,
580: qa_ss_const.asset_number,
573: qa_ss_const.Task_Number,
574: qa_ss_const.To_Department,
575: qa_ss_const.To_Op_Seq_Num,
576: qa_ss_const.UOM,
577: qa_ss_const.Vendor_Name,
578: qa_ss_const.Job_Name,
579: qa_ss_const.asset_group,
580: qa_ss_const.asset_number,
581: --dgupta: R12 EAM Integration. Bug 4345492 Start
574: qa_ss_const.To_Department,
575: qa_ss_const.To_Op_Seq_Num,
576: qa_ss_const.UOM,
577: qa_ss_const.Vendor_Name,
578: qa_ss_const.Job_Name,
579: qa_ss_const.asset_group,
580: qa_ss_const.asset_number,
581: --dgupta: R12 EAM Integration. Bug 4345492 Start
582: qa_ss_const.asset_instance_number,
575: qa_ss_const.To_Op_Seq_Num,
576: qa_ss_const.UOM,
577: qa_ss_const.Vendor_Name,
578: qa_ss_const.Job_Name,
579: qa_ss_const.asset_group,
580: qa_ss_const.asset_number,
581: --dgupta: R12 EAM Integration. Bug 4345492 Start
582: qa_ss_const.asset_instance_number,
583: --dgupta: R12 EAM Integration. Bug 4345492 End
576: qa_ss_const.UOM,
577: qa_ss_const.Vendor_Name,
578: qa_ss_const.Job_Name,
579: qa_ss_const.asset_group,
580: qa_ss_const.asset_number,
581: --dgupta: R12 EAM Integration. Bug 4345492 Start
582: qa_ss_const.asset_instance_number,
583: --dgupta: R12 EAM Integration. Bug 4345492 End
584: qa_ss_const.asset_activity,
578: qa_ss_const.Job_Name,
579: qa_ss_const.asset_group,
580: qa_ss_const.asset_number,
581: --dgupta: R12 EAM Integration. Bug 4345492 Start
582: qa_ss_const.asset_instance_number,
583: --dgupta: R12 EAM Integration. Bug 4345492 End
584: qa_ss_const.asset_activity,
585: qa_ss_const.work_order,
586: qa_ss_const.maintenance_op_seq,
580: qa_ss_const.asset_number,
581: --dgupta: R12 EAM Integration. Bug 4345492 Start
582: qa_ss_const.asset_instance_number,
583: --dgupta: R12 EAM Integration. Bug 4345492 End
584: qa_ss_const.asset_activity,
585: qa_ss_const.work_order,
586: qa_ss_const.maintenance_op_seq,
587: qa_ss_const.followup_activity,
588: qa_ss_const.comp_item,
581: --dgupta: R12 EAM Integration. Bug 4345492 Start
582: qa_ss_const.asset_instance_number,
583: --dgupta: R12 EAM Integration. Bug 4345492 End
584: qa_ss_const.asset_activity,
585: qa_ss_const.work_order,
586: qa_ss_const.maintenance_op_seq,
587: qa_ss_const.followup_activity,
588: qa_ss_const.comp_item,
589: qa_ss_const.serial_number,
582: qa_ss_const.asset_instance_number,
583: --dgupta: R12 EAM Integration. Bug 4345492 End
584: qa_ss_const.asset_activity,
585: qa_ss_const.work_order,
586: qa_ss_const.maintenance_op_seq,
587: qa_ss_const.followup_activity,
588: qa_ss_const.comp_item,
589: qa_ss_const.serial_number,
590: qa_ss_const.lot_number,
583: --dgupta: R12 EAM Integration. Bug 4345492 End
584: qa_ss_const.asset_activity,
585: qa_ss_const.work_order,
586: qa_ss_const.maintenance_op_seq,
587: qa_ss_const.followup_activity,
588: qa_ss_const.comp_item,
589: qa_ss_const.serial_number,
590: qa_ss_const.lot_number,
591: qa_ss_const.comp_lot_number,
584: qa_ss_const.asset_activity,
585: qa_ss_const.work_order,
586: qa_ss_const.maintenance_op_seq,
587: qa_ss_const.followup_activity,
588: qa_ss_const.comp_item,
589: qa_ss_const.serial_number,
590: qa_ss_const.lot_number,
591: qa_ss_const.comp_lot_number,
592: qa_ss_const.comp_serial_number,
585: qa_ss_const.work_order,
586: qa_ss_const.maintenance_op_seq,
587: qa_ss_const.followup_activity,
588: qa_ss_const.comp_item,
589: qa_ss_const.serial_number,
590: qa_ss_const.lot_number,
591: qa_ss_const.comp_lot_number,
592: qa_ss_const.comp_serial_number,
593: /* R12 DR Integration. Bug 4345489 */
586: qa_ss_const.maintenance_op_seq,
587: qa_ss_const.followup_activity,
588: qa_ss_const.comp_item,
589: qa_ss_const.serial_number,
590: qa_ss_const.lot_number,
591: qa_ss_const.comp_lot_number,
592: qa_ss_const.comp_serial_number,
593: /* R12 DR Integration. Bug 4345489 */
594: qa_ss_const.repair_order_number,
587: qa_ss_const.followup_activity,
588: qa_ss_const.comp_item,
589: qa_ss_const.serial_number,
590: qa_ss_const.lot_number,
591: qa_ss_const.comp_lot_number,
592: qa_ss_const.comp_serial_number,
593: /* R12 DR Integration. Bug 4345489 */
594: qa_ss_const.repair_order_number,
595: qa_ss_const.jtf_task_number,
588: qa_ss_const.comp_item,
589: qa_ss_const.serial_number,
590: qa_ss_const.lot_number,
591: qa_ss_const.comp_lot_number,
592: qa_ss_const.comp_serial_number,
593: /* R12 DR Integration. Bug 4345489 */
594: qa_ss_const.repair_order_number,
595: qa_ss_const.jtf_task_number,
596: /* R12 DR Integration. Bug 4345489 */
590: qa_ss_const.lot_number,
591: qa_ss_const.comp_lot_number,
592: qa_ss_const.comp_serial_number,
593: /* R12 DR Integration. Bug 4345489 */
594: qa_ss_const.repair_order_number,
595: qa_ss_const.jtf_task_number,
596: /* R12 DR Integration. Bug 4345489 */
597: -- R12 OPM Deviations. Bug 4345503 Start
598: qa_ss_const.process_batch_num,
591: qa_ss_const.comp_lot_number,
592: qa_ss_const.comp_serial_number,
593: /* R12 DR Integration. Bug 4345489 */
594: qa_ss_const.repair_order_number,
595: qa_ss_const.jtf_task_number,
596: /* R12 DR Integration. Bug 4345489 */
597: -- R12 OPM Deviations. Bug 4345503 Start
598: qa_ss_const.process_batch_num,
599: qa_ss_const.process_batchstep_num,
594: qa_ss_const.repair_order_number,
595: qa_ss_const.jtf_task_number,
596: /* R12 DR Integration. Bug 4345489 */
597: -- R12 OPM Deviations. Bug 4345503 Start
598: qa_ss_const.process_batch_num,
599: qa_ss_const.process_batchstep_num,
600: qa_ss_const.process_operation,
601: qa_ss_const.process_activity,
602: qa_ss_const.process_resource,
595: qa_ss_const.jtf_task_number,
596: /* R12 DR Integration. Bug 4345489 */
597: -- R12 OPM Deviations. Bug 4345503 Start
598: qa_ss_const.process_batch_num,
599: qa_ss_const.process_batchstep_num,
600: qa_ss_const.process_operation,
601: qa_ss_const.process_activity,
602: qa_ss_const.process_resource,
603: qa_ss_const.process_parameter,
596: /* R12 DR Integration. Bug 4345489 */
597: -- R12 OPM Deviations. Bug 4345503 Start
598: qa_ss_const.process_batch_num,
599: qa_ss_const.process_batchstep_num,
600: qa_ss_const.process_operation,
601: qa_ss_const.process_activity,
602: qa_ss_const.process_resource,
603: qa_ss_const.process_parameter,
604: -- R12 OPM Deviations. Bug 4345503 End
597: -- R12 OPM Deviations. Bug 4345503 Start
598: qa_ss_const.process_batch_num,
599: qa_ss_const.process_batchstep_num,
600: qa_ss_const.process_operation,
601: qa_ss_const.process_activity,
602: qa_ss_const.process_resource,
603: qa_ss_const.process_parameter,
604: -- R12 OPM Deviations. Bug 4345503 End
605: -- added to_locator. Bug 13638890. hmakam
598: qa_ss_const.process_batch_num,
599: qa_ss_const.process_batchstep_num,
600: qa_ss_const.process_operation,
601: qa_ss_const.process_activity,
602: qa_ss_const.process_resource,
603: qa_ss_const.process_parameter,
604: -- R12 OPM Deviations. Bug 4345503 End
605: -- added to_locator. Bug 13638890. hmakam
606: qa_ss_const.to_locator
599: qa_ss_const.process_batchstep_num,
600: qa_ss_const.process_operation,
601: qa_ss_const.process_activity,
602: qa_ss_const.process_resource,
603: qa_ss_const.process_parameter,
604: -- R12 OPM Deviations. Bug 4345503 End
605: -- added to_locator. Bug 13638890. hmakam
606: qa_ss_const.to_locator
607: )
602: qa_ss_const.process_resource,
603: qa_ss_const.process_parameter,
604: -- R12 OPM Deviations. Bug 4345503 End
605: -- added to_locator. Bug 13638890. hmakam
606: qa_ss_const.to_locator
607: )
608: ) THEN
609:
610: RETURN TRUE;