DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 1446: PO_DISTRIBUTIONS_ALL PD,

1442: UPDATE po_headers_all POH
1443: SET POH.closed_date = g_sweep_to_date
1444: WHERE po_header_id in (SELECT PLL.PO_HEADER_ID
1445: FROM PO_LINE_LOCATIONS_ALL PLL,
1446: PO_DISTRIBUTIONS_ALL PD,
1447: AP_PERIOD_CLOSE_EXCPS_GT GT
1448: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
1449: AND PD.PO_DISTRIBUTION_ID = GT.PO_DISTRIBUTION_ID
1450: AND GT.SOURCE_TYPE = G_SRC_TYP_UNACCT_DISTS

Line 1467: PO_DISTRIBUTIONS_ALL PD,

1463: UPDATE po_line_locations_all
1464: SET closed_date = g_sweep_to_date
1465: WHERE line_location_id in (SELECT PLL.LINE_LOCATION_ID
1466: FROM PO_LINE_LOCATIONS_ALL PLL,
1467: PO_DISTRIBUTIONS_ALL PD,
1468: AP_PERIOD_CLOSE_EXCPS_GT GT
1469: WHERE PLL.LINE_LOCATION_ID = PD.LINE_LOCATION_ID
1470: AND PD.PO_DISTRIBUTION_ID = GT.PO_DISTRIBUTION_ID
1471: AND GT.SOURCE_TYPE = G_SRC_TYP_UNACCT_DISTS