APPS.PO_CHORD_WF2 dependencies on PO_CHORD_WF0

Line 616: SELECT max(po_chord_wf0.percentage_change(

612: -- line quantity
613: -- SQL Why: Need the value in tolerance check (i.e reapproval
614: -- rule validations)
615: -- SQL Join: po_line_id
616: SELECT max(po_chord_wf0.percentage_change(
617: POLA.quantity, POL.quantity))
618: INTO x_lines_control.quantity_change
619: FROM PO_LINES_ALL POL,
620: PO_LINES_ARCHIVE_ALL POLA

Line 636: SELECT max(po_chord_wf0.percentage_change(

632: -- unit price
633: -- SQL Why: Need the value in tolerance check (i.e reapproval
634: -- rule validations)
635: -- SQL Join: po_line_id
636: SELECT max(po_chord_wf0.percentage_change(
637: POLA.unit_price, POL.unit_price))
638: INTO x_lines_control.unit_price_change
639: FROM PO_LINES_ALL POL,
640: PO_LINES_ARCHIVE_ALL POLA

Line 656: SELECT max(po_chord_wf0.percentage_change(

652: -- exceed price tolerance
653: -- SQL Why: Need the value in tolerance check (i.e reapproval
654: -- rule validations)
655: -- SQL Join: po_line_id
656: SELECT max(po_chord_wf0.percentage_change(
657: POLA.not_to_exceed_price, POL.not_to_exceed_price))
658: INTO x_lines_control.not_to_exceed_price_change
659: FROM PO_LINES_ALL POL,
660: PO_LINES_ARCHIVE_ALL POLA

Line 676: SELECT max(po_chord_wf0.percentage_change(

672: -- commited quantity
673: -- SQL Why: Need the value in tolerance check (i.e reapproval
674: -- rule validations)
675: -- SQL Join: po_line_id
676: SELECT max(po_chord_wf0.percentage_change(
677: POLA.quantity_committed, POL.quantity_committed))
678: INTO x_lines_control.quantity_committed_change
679: FROM PO_LINES_ALL POL,
680: PO_LINES_ARCHIVE_ALL POLA

Line 696: SELECT max(po_chord_wf0.percentage_change(

692: -- commited amount
693: -- SQL Why: Need the value in tolerance check (i.e reapproval
694: -- rule validations)
695: -- SQL Join: po_line_id
696: SELECT max(po_chord_wf0.percentage_change(
697: POLA.committed_amount, POL.committed_amount))
698: INTO x_lines_control.committed_amount_change
699: FROM PO_LINES_ALL POL,
700: PO_LINES_ARCHIVE_ALL POLA

Line 734: SELECT max(po_chord_wf0.percentage_change(

730:
731: IF l_min_acct_unit is not null AND
732: l_min_acct_unit <> 0 THEN
733:
734: SELECT max(po_chord_wf0.percentage_change(
735: round(
736: decode(POLA.order_type_lookup_code, 'RATE',POLA.amount,'FIXED PRICE', POLA.amount,
737: (POLA.quantity*POLA.unit_price)) / l_min_acct_unit )* l_min_acct_unit ,
738: round(

Line 750: SELECT max(po_chord_wf0.percentage_change(

746: AND POL.po_line_id = POLA.po_line_id (+)
747: AND POLA.latest_external_flag (+) = 'Y';
748:
749: ELSE
750: SELECT max(po_chord_wf0.percentage_change(
751: round(
752: decode(POLA.order_type_lookup_code, 'RATE',POLA.amount,'FIXED PRICE', POLA.amount,
753: (POLA.quantity*POLA.unit_price )) , l_precision) ,
754: round(