APPS.PO_CHORD_WF3 dependencies on PO_CHORD_WF0

Line 833: SELECT max(po_chord_wf0.percentage_change(

829: -- rule validations)
830: -- SQL Join: line_location_id
831: IF (x_po_header_id IS NOT NULL) THEN
832: BEGIN
833: SELECT max(po_chord_wf0.percentage_change(
834: POLLA.quantity, POLL.quantity))
835: INTO x_shipments_control.quantity_change
836: FROM PO_LINE_LOCATIONS_ALL POLL,
837: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

Line 849: SELECT max(po_chord_wf0.percentage_change(

845: x_shipments_control.quantity_change := 0;
846: END;
847: ELSE
848: BEGIN
849: SELECT max(po_chord_wf0.percentage_change(
850: POLLA.quantity, POLL.quantity))
851: INTO x_shipments_control.quantity_change
852: FROM PO_LINE_LOCATIONS_ALL POLL,
853: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

Line 870: SELECT max(po_chord_wf0.percentage_change(

866: -- rule validations)
867: -- SQL Join: line_location_id
868: IF (x_po_header_id IS NOT NULL) THEN
869: BEGIN
870: SELECT max(po_chord_wf0.percentage_change(
871: POLLA.price_override, POLL.price_override))
872: INTO x_shipments_control.price_override_change
873: FROM PO_LINE_LOCATIONS_ALL POLL,
874: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

Line 886: SELECT max(po_chord_wf0.percentage_change(

882: x_shipments_control.price_override_change := 0;
883: END;
884: ELSE
885: BEGIN
886: SELECT max(po_chord_wf0.percentage_change(
887: POLLA.price_override, POLL.price_override))
888: INTO x_shipments_control.price_override_change
889: FROM PO_LINE_LOCATIONS_ALL POLL,
890: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

Line 925: SELECT max(po_chord_wf0.percentage_change(

921: BEGIN
922: IF l_min_acct_unit is not null AND
923: l_min_acct_unit <> 0 THEN
924:
925: SELECT max(po_chord_wf0.percentage_change(
926: round(
927: decode(POLLA.value_basis, 'RATE',POLLA.amount,'FIXED PRICE', POLLA.amount,
928: (POLLA.quantity*POLLA.price_override)) / l_min_acct_unit )* l_min_acct_unit ,
929: round(

Line 945: SELECT max(po_chord_wf0.percentage_change(

941: AND poll.po_release_id is NULL; -- Bug 4016493 : Ignore release shipments
942:
943: ELSE
944:
945: SELECT max(po_chord_wf0.percentage_change(
946: round(
947: decode(POLLA.value_basis, 'RATE',POLLA.amount,'FIXED PRICE', POLLA.amount,
948: (POLLA.quantity*POLLA.price_override)) ,l_precision ) ,
949: round(

Line 988: SELECT max(po_chord_wf0.percentage_change(

984: BEGIN
985: IF l_min_acct_unit is not null AND
986: l_min_acct_unit <> 0 THEN
987:
988: SELECT max(po_chord_wf0.percentage_change(
989: round(
990: decode(POLLA.value_basis,'FIXED PRICE', POLLA.amount,
991: (POLLA.quantity*POLLA.price_override)) / l_min_acct_unit )* l_min_acct_unit ,
992: round(

Line 1005: SELECT max(po_chord_wf0.percentage_change(

1001: AND POLLA.latest_external_flag (+) = 'Y';
1002:
1003: ELSE
1004:
1005: SELECT max(po_chord_wf0.percentage_change(
1006: round(
1007: decode(POLLA.value_basis,'FIXED PRICE', POLLA.amount,
1008: (POLLA.quantity*POLLA.price_override)) ,l_precision ) ,
1009: round(