eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ITG_SYNCPOINBOUND_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 444: FROM po_distributions_all

440: quantity_ordered,
441: quantity_billed,
442: quantity_delivered,
443: amount_billed
444: FROM po_distributions_all
445: WHERE line_location_id = p_line_loc_id;
446:
447: TYPE po_dist_rec IS RECORD (
448: po_distribution_id po_distributions_all.po_distribution_id%TYPE,

Line 448: po_distribution_id po_distributions_all.po_distribution_id%TYPE,

444: FROM po_distributions_all
445: WHERE line_location_id = p_line_loc_id;
446:
447: TYPE po_dist_rec IS RECORD (
448: po_distribution_id po_distributions_all.po_distribution_id%TYPE,
449: quantity_ordered po_distributions_all.quantity_ordered%TYPE,
450: quantity_billed po_distributions_all.quantity_billed%TYPE,
451: quantity_delivered po_distributions_all.quantity_delivered%TYPE,
452: amount_billed po_distributions_all.amount_billed%TYPE);

Line 449: quantity_ordered po_distributions_all.quantity_ordered%TYPE,

445: WHERE line_location_id = p_line_loc_id;
446:
447: TYPE po_dist_rec IS RECORD (
448: po_distribution_id po_distributions_all.po_distribution_id%TYPE,
449: quantity_ordered po_distributions_all.quantity_ordered%TYPE,
450: quantity_billed po_distributions_all.quantity_billed%TYPE,
451: quantity_delivered po_distributions_all.quantity_delivered%TYPE,
452: amount_billed po_distributions_all.amount_billed%TYPE);
453:

Line 450: quantity_billed po_distributions_all.quantity_billed%TYPE,

446:
447: TYPE po_dist_rec IS RECORD (
448: po_distribution_id po_distributions_all.po_distribution_id%TYPE,
449: quantity_ordered po_distributions_all.quantity_ordered%TYPE,
450: quantity_billed po_distributions_all.quantity_billed%TYPE,
451: quantity_delivered po_distributions_all.quantity_delivered%TYPE,
452: amount_billed po_distributions_all.amount_billed%TYPE);
453:
454: TYPE po_dist_tab IS TABLE OF po_dist_rec

Line 451: quantity_delivered po_distributions_all.quantity_delivered%TYPE,

447: TYPE po_dist_rec IS RECORD (
448: po_distribution_id po_distributions_all.po_distribution_id%TYPE,
449: quantity_ordered po_distributions_all.quantity_ordered%TYPE,
450: quantity_billed po_distributions_all.quantity_billed%TYPE,
451: quantity_delivered po_distributions_all.quantity_delivered%TYPE,
452: amount_billed po_distributions_all.amount_billed%TYPE);
453:
454: TYPE po_dist_tab IS TABLE OF po_dist_rec
455: INDEX BY BINARY_INTEGER;

Line 452: amount_billed po_distributions_all.amount_billed%TYPE);

448: po_distribution_id po_distributions_all.po_distribution_id%TYPE,
449: quantity_ordered po_distributions_all.quantity_ordered%TYPE,
450: quantity_billed po_distributions_all.quantity_billed%TYPE,
451: quantity_delivered po_distributions_all.quantity_delivered%TYPE,
452: amount_billed po_distributions_all.amount_billed%TYPE);
453:
454: TYPE po_dist_tab IS TABLE OF po_dist_rec
455: INDEX BY BINARY_INTEGER;
456:

Line 570: ITG_Debug.msg('AAD', 'Update po_distributions_all ...');

566: RAISE FND_API.G_EXC_ERROR;
567: END IF;
568:
569: /* Ok time to update the table.. */
570: ITG_Debug.msg('AAD', 'Update po_distributions_all ...');
571: IF p_doc_type = 'RECEIPT' THEN
572: FOR i IN 1 .. l_disttab.COUNT LOOP
573: UPDATE po_distributions_all
574: SET quantity_delivered = l_disttab(i).quantity_delivered,

Line 573: UPDATE po_distributions_all

569: /* Ok time to update the table.. */
570: ITG_Debug.msg('AAD', 'Update po_distributions_all ...');
571: IF p_doc_type = 'RECEIPT' THEN
572: FOR i IN 1 .. l_disttab.COUNT LOOP
573: UPDATE po_distributions_all
574: SET quantity_delivered = l_disttab(i).quantity_delivered,
575: last_update_date = SYSDATE,
576: last_updated_by = FND_GLOBAL.user_id
577: WHERE po_distribution_id = l_disttab(i).po_distribution_id;

Line 585: UPDATE po_distributions_all

581: l_disttab(i).quantity_delivered);
582: END LOOP;
583: ELSIF p_doc_type = 'INVOICE' THEN
584: FOR i IN 1 .. l_disttab.COUNT LOOP
585: UPDATE po_distributions_all
586: SET quantity_billed = l_disttab(i).quantity_billed,
587: amount_billed = NVL(amount_billed,0) +
588: (l_disttab(i).quantity_billed / p_quantity) *
589: p_total_amount,