APPS.PO_CHORD_WF3 dependencies on PO_CHORD_WF0

Line 837: SELECT max(po_chord_wf0.percentage_change(

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

Line 853: SELECT max(po_chord_wf0.percentage_change(

849: x_shipments_control.quantity_change := 0;
850: END;
851: ELSE
852: BEGIN
853: SELECT max(po_chord_wf0.percentage_change(
854: POLLA.quantity, POLL.quantity))
855: INTO x_shipments_control.quantity_change
856: FROM PO_LINE_LOCATIONS_ALL POLL,
857: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

Line 874: SELECT max(po_chord_wf0.percentage_change(

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

Line 890: SELECT max(po_chord_wf0.percentage_change(

886: x_shipments_control.price_override_change := 0;
887: END;
888: ELSE
889: BEGIN
890: SELECT max(po_chord_wf0.percentage_change(
891: POLLA.price_override, POLL.price_override))
892: INTO x_shipments_control.price_override_change
893: FROM PO_LINE_LOCATIONS_ALL POLL,
894: PO_LINE_LOCATIONS_ARCHIVE_ALL POLLA

Line 929: SELECT max(po_chord_wf0.percentage_change(

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

Line 949: SELECT max(po_chord_wf0.percentage_change(

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

Line 992: SELECT max(po_chord_wf0.percentage_change(

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

Line 1009: SELECT max(po_chord_wf0.percentage_change(

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