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

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 129: FROM po_line_locations pll2

125: WHERE pll.line_location_id = p_line_loc_changes_rec.po_line_location_id
126: OR (pll.shipment_type = 'PLANNED'
127: AND pll.line_location_id =
128: (SELECT pll2.source_shipment_id
129: FROM po_line_locations pll2
130: WHERE pll2.shipment_type = 'SCHEDULED'
131: AND pll2.line_location_id = p_line_loc_changes_rec.po_line_location_id)
132: )
133: ;

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 431: FROM po_line_locations pll,

427: SELECT pll.amount,
428: pll.amount_cancelled
429: INTO x_ship_amt_ordered,
430: x_ship_amt_cancelled
431: FROM po_line_locations pll,
432: rcv_transactions rt
433: WHERE rt.po_line_location_id = pll.line_location_id
434: AND rt.transaction_id = p_receive_transaction_id;
435:

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 679: -- Possible values: PO_HEADERS, PO_LINES, PO_LINE_LOCATIONS, PO_DISTRIBUTIONS

675: --IN:
676: -- p_api_version
677: -- Specifies the version of the api. Value that needs to be passed in is 1.0
678: -- p_entity_type
679: -- Possible values: PO_HEADERS, PO_LINES, PO_LINE_LOCATIONS, PO_DISTRIBUTIONS
680: -- PO_LINE_LOCATIONS only supported currently.
681: -- p_entity_id_tbl
682: -- This will have one or more ids that you want to set the final match flag value.
683: -- p_final_match_flag

Line 680: -- PO_LINE_LOCATIONS only supported currently.

676: -- p_api_version
677: -- Specifies the version of the api. Value that needs to be passed in is 1.0
678: -- p_entity_type
679: -- Possible values: PO_HEADERS, PO_LINES, PO_LINE_LOCATIONS, PO_DISTRIBUTIONS
680: -- PO_LINE_LOCATIONS only supported currently.
681: -- p_entity_id_tbl
682: -- This will have one or more ids that you want to set the final match flag value.
683: -- p_final_match_flag
684: -- Possible Values: Y or N

Line 707: p_final_match_flag IN PO_LINE_LOCATIONS.FINAL_MATCH_FLAG%TYPE ,

703:
704: PROCEDURE set_final_match_flag (p_api_version IN NUMBER ,
705: p_entity_type IN VARCHAR2 ,
706: p_entity_id_tbl IN PO_TBL_NUMBER ,
707: p_final_match_flag IN PO_LINE_LOCATIONS.FINAL_MATCH_FLAG%TYPE ,
708: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
709: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
710: x_ret_status OUT NOCOPY VARCHAR2 ,
711: x_msg_count OUT NOCOPY NUMBER ,

Line 738: IF p_entity_type <> 'PO_LINE_LOCATIONS' THEN

734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735:
736: END IF;
737:
738: IF p_entity_type <> 'PO_LINE_LOCATIONS' THEN
739:
740: RAISE FND_API.G_EXC_ERROR;
741:
742: ELSE

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;