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.PO_AP_INVOICE_MATCH_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 90: UPDATE po_line_locations_all pll

86: -- SQL What: Update the AP-related fields on the PO line location
87: -- SQL Where: For the line location row represented in p_line_loc_changes_rec
88: -- Also, for Scheduled Releases, update the information on the
89: -- backing Planned PO line location row as well
90: UPDATE po_line_locations_all pll
91: SET quantity_billed =
92: DECODE(p_line_loc_changes_rec.quantity_billed
93: , NULL, quantity_billed
94: , nvl(quantity_billed, 0) + p_line_loc_changes_rec.quantity_billed),

Line 309: PO_LINE_LOCATIONS_ALL PLL,

305: least(p_line_loc_match_amt_tbl(i) * (POL.retainage_rate/100),POL.max_retainage_amount - nvl(PO_LINES_INT.retained_amount,0)),
306: p_line_loc_match_amt_tbl(i) * (POL.retainage_rate/100)
307: )
308: FROM PO_LINES_ALL POL,
309: PO_LINE_LOCATIONS_ALL PLL,
310: ( select PLL1.po_line_id ,
311: SUM(PLL1.RETAINAGE_WITHHELD_AMOUNT) retained_amount
312: FROM PO_LINE_LOCATIONS_ALL PLL1
313: WHERE PLL1.po_line_id = (select po_line_id from po_line_locations_all PLL2

Line 312: FROM PO_LINE_LOCATIONS_ALL PLL1

308: FROM PO_LINES_ALL POL,
309: PO_LINE_LOCATIONS_ALL PLL,
310: ( select PLL1.po_line_id ,
311: SUM(PLL1.RETAINAGE_WITHHELD_AMOUNT) retained_amount
312: FROM PO_LINE_LOCATIONS_ALL PLL1
313: WHERE PLL1.po_line_id = (select po_line_id from po_line_locations_all PLL2
314: where PLL2.line_location_id = p_line_location_id_tbl(i))
315: GROUP BY PLL1.po_line_id
316: ) PO_LINES_INT

Line 313: WHERE PLL1.po_line_id = (select po_line_id from po_line_locations_all PLL2

309: PO_LINE_LOCATIONS_ALL PLL,
310: ( select PLL1.po_line_id ,
311: SUM(PLL1.RETAINAGE_WITHHELD_AMOUNT) retained_amount
312: FROM PO_LINE_LOCATIONS_ALL PLL1
313: WHERE PLL1.po_line_id = (select po_line_id from po_line_locations_all PLL2
314: where PLL2.line_location_id = p_line_location_id_tbl(i))
315: GROUP BY PLL1.po_line_id
316: ) PO_LINES_INT
317: WHERE PLL.line_location_id = p_line_location_id_tbl(i)

Line 403: x_ship_amt_ordered OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount%TYPE,

399: -------------------------------------------------------------------------------------------------
400:
401: PROCEDURE get_po_ship_amounts (p_api_version IN NUMBER,
402: p_receive_transaction_id IN RCV_TRANSACTIONS.transaction_id%TYPE,
403: x_ship_amt_ordered OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount%TYPE,
404: x_ship_amt_cancelled OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount_cancelled%TYPE,
405: x_ret_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 404: x_ship_amt_cancelled OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount_cancelled%TYPE,

400:
401: PROCEDURE get_po_ship_amounts (p_api_version IN NUMBER,
402: p_receive_transaction_id IN RCV_TRANSACTIONS.transaction_id%TYPE,
403: x_ship_amt_ordered OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount%TYPE,
404: x_ship_amt_cancelled OUT NOCOPY PO_LINE_LOCATIONS_ALL.amount_cancelled%TYPE,
405: x_ret_status OUT NOCOPY VARCHAR2,
406: x_msg_count OUT NOCOPY NUMBER,
407: x_msg_data OUT NOCOPY VARCHAR2) IS
408:

Line 526: --Modifies: PO_LINE_LOCATIONS_ALL

522: --Name: update_po_ship_amounts
523: --
524: --Pre-reqs: None
525: --
526: --Modifies: PO_LINE_LOCATIONS_ALL
527: --
528: --Locks: None
529: --
530: --Function: This procedure updates the amount billed on po shipments during amount matching process

Line 557: p_po_line_location_id IN PO_LINE_LOCATIONS_ALL.line_location_id%TYPE,

553: --End of Comments
554: ------------------------------------------------------------------------------------------------
555:
556: PROCEDURE update_po_ship_amounts (p_api_version IN NUMBER,
557: p_po_line_location_id IN PO_LINE_LOCATIONS_ALL.line_location_id%TYPE,
558: p_ship_amt_billed IN PO_LINE_LOCATIONS_ALL.amount_billed%TYPE,
559: x_ret_status OUT NOCOPY VARCHAR2,
560: x_msg_count OUT NOCOPY NUMBER,
561: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 558: p_ship_amt_billed IN PO_LINE_LOCATIONS_ALL.amount_billed%TYPE,

554: ------------------------------------------------------------------------------------------------
555:
556: PROCEDURE update_po_ship_amounts (p_api_version IN NUMBER,
557: p_po_line_location_id IN PO_LINE_LOCATIONS_ALL.line_location_id%TYPE,
558: p_ship_amt_billed IN PO_LINE_LOCATIONS_ALL.amount_billed%TYPE,
559: x_ret_status OUT NOCOPY VARCHAR2,
560: x_msg_count OUT NOCOPY NUMBER,
561: x_msg_data OUT NOCOPY VARCHAR2) IS
562:

Line 580: UPDATE po_line_locations_all

576:
577: -- SQL What : Updates the amount billed on the po shipments
578: -- SQL Why : This is the amount that was billed against this shipment
579:
580: UPDATE po_line_locations_all
581: SET amount_billed = nvl(amount_billed,0) + nvl(p_ship_amt_billed,0)
582: WHERE line_location_id = p_po_line_location_id;
583:
584:

Line 667: --Modifies: PO_LINE_LOCATIONS_ALL

663: --Name: set_final_match_flag
664: --
665: --Pre-reqs: None
666: --
667: --Modifies: PO_LINE_LOCATIONS_ALL
668: --
669: --Locks: None
670: --
671: --Function: This procedure updates the final_match_flag on po shipments when an invoice is finally matched.

Line 748: UPDATE po_line_locations_all

744: -- SQL Why : This is to indicate the shipment has been finally matched by an invoice.
745:
746: FORALL i IN 1 .. p_entity_id_tbl.COUNT
747:
748: UPDATE po_line_locations_all
749: SET final_match_flag = p_final_match_flag
750: WHERE line_location_id = p_entity_id_tbl(i);
751:
752: END IF;