APPS.PO_CHORD_WF4 dependencies on PO_CHORD_WF0

Line 411: SELECT max(po_chord_wf0.percentage_change(

407: -- SQL Join: po_distribution_id
408: IF (x_po_header_id IS NOT NULL) THEN
409: BEGIN
410:
411: SELECT max(po_chord_wf0.percentage_change(
412: PODA.quantity_ordered, POD.quantity_ordered))
413: INTO x_dist_control.quantity_ordered_change
414: FROM PO_DISTRIBUTIONS_ALL POD,
415: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

Line 429: SELECT max(po_chord_wf0.percentage_change(

425: END;
426: ELSE
427: BEGIN
428:
429: SELECT max(po_chord_wf0.percentage_change(
430: PODA.quantity_ordered, POD.quantity_ordered))
431: INTO x_dist_control.quantity_ordered_change
432: FROM PO_DISTRIBUTIONS_ALL POD,
433: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

Line 450: SELECT max(po_chord_wf0.percentage_change(

446: -- rule validations)
447: -- SQL Join: po_distribution_id
448: IF (x_po_header_id IS NOT NULL) THEN
449: BEGIN
450: SELECT max(po_chord_wf0.percentage_change(
451: PODA.rate, POD.rate))
452: INTO x_dist_control.rate_change
453: FROM PO_DISTRIBUTIONS_ALL POD,
454: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

Line 468: SELECT max(po_chord_wf0.percentage_change(

464: END;
465: ELSE
466: BEGIN
467:
468: SELECT max(po_chord_wf0.percentage_change(
469: PODA.rate, POD.rate))
470: INTO x_dist_control.rate_change
471: FROM PO_DISTRIBUTIONS_ALL POD,
472: PO_DISTRIBUTIONS_ARCHIVE_ALL PODA

Line 510: SELECT max(po_chord_wf0.percentage_change(

506:
507: IF l_min_acct_unit is not null AND
508: l_min_acct_unit <> 0 THEN
509:
510: SELECT max(po_chord_wf0.percentage_change(
511: round (
512: decode(POLLA.value_basis, 'RATE',PODA.amount_ordered,'FIXED PRICE', PODA.amount_ordered,
513: (PODA.quantity_ordered*POLLA.price_override))/ l_min_acct_unit )* l_min_acct_unit ,
514: round (

Line 534: SELECT max(po_chord_wf0.percentage_change(

530: AND POLLA.latest_external_flag (+) = 'Y' -- Bug 5071741
531: AND POLL.po_release_id is NULL; -- Bug 5071741
532:
533: ELSE
534: SELECT max(po_chord_wf0.percentage_change(
535: round (
536: decode(POLLA.value_basis, 'RATE',PODA.amount_ordered,'FIXED PRICE', PODA.amount_ordered,
537: (PODA.quantity_ordered*POLLA.price_override)), l_precision ) ,
538: round (

Line 583: SELECT max(po_chord_wf0.percentage_change(

579:
580: IF l_min_acct_unit is not null AND
581: l_min_acct_unit <> 0 THEN
582:
583: SELECT max(po_chord_wf0.percentage_change(
584: round (
585: decode(POLLA.value_basis,'FIXED PRICE', PODA.amount_ordered,
586: (PODA.quantity_ordered*POLLA.price_override))/ l_min_acct_unit )* l_min_acct_unit ,
587: round (

Line 606: SELECT max(po_chord_wf0.percentage_change(

602: AND POLLA.latest_external_flag (+) = 'Y'; -- Bug 5071741
603:
604: ELSE
605:
606: SELECT max(po_chord_wf0.percentage_change(
607: round (
608: decode(POLLA.value_basis,'FIXED PRICE', PODA.amount_ordered,
609: (PODA.quantity_ordered*POLLA.price_override)) , l_precision ) ,
610: round (