DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 962: po_distributions_all pd1

958: pd1.po_release_id,
959: pd1.amount_ordered,
960: pd1.amount_delivered
961: FROM po_lines_all pol,
962: po_distributions_all pd1
963: WHERE pol.po_line_id = pd1.po_line_id
964: )
965: pd
966: WHERE pd.line_type_id = plt.line_type_id

Line 1263: po_distributions_all pd1

1259: pd1.po_release_id,
1260: pd1.amount_ordered,
1261: pd1.amount_delivered
1262: FROM po_lines_all pol,
1263: po_distributions_all pd1
1264: WHERE pol.po_line_id = pd1.po_line_id
1265: )
1266: pd
1267: WHERE pd.line_type_id = plt.line_type_id

Line 1573: po_distributions_all pd1

1569: pd1.po_release_id,
1570: pd1.amount_ordered,
1571: pd1.amount_delivered
1572: FROM po_lines_all pol,
1573: po_distributions_all pd1
1574: WHERE pol.po_line_id = pd1.po_line_id
1575: )
1576: pd
1577: WHERE pd.line_type_id = plt.line_type_id

Line 1714: FROM PO_DISTRIBUTIONS_ALL PD,

1710: x_return_string OUT NOCOPY VARCHAR2 /* Added for bug# 5335940 */) IS
1711:
1712: CURSOR disc_check_po_req_cur IS
1713: SELECT 'PO/REQ Linked'
1714: FROM PO_DISTRIBUTIONS_ALL PD,
1715: PO_LINE_LOCATIONS_ALL PLL
1716: WHERE pd.po_line_id IS NOT NULL
1717: AND pd.line_location_id IS NOT NULL
1718: AND PD.WIP_ENTITY_ID = p_wip_id