DBA Data[Home] [Help]

APPS.POA_SUPPERF_API_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 707: -- - po_line_locations_all - last_update_date

703: -- This procedure returns the last update date for a particular
704: -- shipment line.
705: -- The dates considered are for:
706: -- - rcv_transactions - last_update_date
707: -- - po_line_locations_all - last_update_date
708: -- If any of these records changed after the last collection,
709: -- the shipment data need to be re-collected.
710: --
711: FUNCTION get_last_trx_date(p_line_location_id NUMBER)

Line 738: -- Get max date from po_line_locations_all

734:
735: x_progress := '002';
736:
737: --
738: -- Get max date from po_line_locations_all
739: --
740: BEGIN
741: SELECT last_update_date
742: INTO v_shipment_date

Line 743: FROM po_line_locations_all

739: --
740: BEGIN
741: SELECT last_update_date
742: INTO v_shipment_date
743: FROM po_line_locations_all
744: WHERE line_location_id = p_line_location_id;
745: END;
746:
747: RETURN(GREATEST(NVL(v_max_rcv_date, v_shipment_date - 1),