DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 1709: PO_DISTRIBUTIONS_ALL PD,

1705: UPDATE po_headers_all POH
1706: SET POH.closed_date = g_sweep_to_date
1707: WHERE po_header_id in (SELECT PLL.PO_HEADER_ID
1708: FROM PO_LINE_LOCATIONS_ALL PLL,
1709: PO_DISTRIBUTIONS_ALL PD,
1710: AP_PERIOD_CLOSE_EXCPS_GT GT
1711: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
1712: AND PD.PO_DISTRIBUTION_ID = GT.PO_DISTRIBUTION_ID
1713: AND GT.SOURCE_TYPE = G_SRC_TYP_UNACCT_DISTS

Line 1730: PO_DISTRIBUTIONS_ALL PD,

1726: UPDATE po_line_locations_all
1727: SET closed_date = g_sweep_to_date
1728: WHERE line_location_id in (SELECT PLL.LINE_LOCATION_ID
1729: FROM PO_LINE_LOCATIONS_ALL PLL,
1730: PO_DISTRIBUTIONS_ALL PD,
1731: AP_PERIOD_CLOSE_EXCPS_GT GT
1732: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
1733: AND PD.PO_DISTRIBUTION_ID = GT.PO_DISTRIBUTION_ID
1734: AND GT.SOURCE_TYPE = G_SRC_TYP_UNACCT_DISTS