APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LINES_ALL

Line 1168: FROM PO_LINES_ALL POL,

1164: , POL.catalog_name --
1165: , POL.supplier_part_auxid --
1166: , POL.ip_category_id --
1167: , POL.last_updated_program --
1168: FROM PO_LINES_ALL POL,
1169: PO_LINES_ARCHIVE_ALL POLA
1170: WHERE POL.po_header_id = p_document_id
1171: AND POL.po_line_id = POLA.po_line_id (+)
1172: AND POLA.latest_external_flag (+) = 'Y'

Line 2501: FROM PO_LINES_ALL

2497: FROM PO_LINE_LOCATIONS_ALL
2498: WHERE po_header_id = p_document_id)) OR
2499: (p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
2500: POR.entity_id IN (SELECT po_line_id
2501: FROM PO_LINES_ALL
2502: WHERE po_header_id = p_document_id)))
2503: AND POR.entity_type = p_entity_type
2504: AND POR.price_differential_id = PORA.price_differential_id (+)
2505: AND PORA.latest_external_flag (+) = 'Y'

Line 2545: FROM PO_LINES_ALL

2541: FROM PO_LINE_LOCATIONS_ALL
2542: WHERE po_header_id = p_document_id)) OR
2543: (p_entity_type IN ('PO LINE', 'BLANKET LINE') AND
2544: entity_id IN (SELECT po_line_id
2545: FROM PO_LINES_ALL
2546: WHERE po_header_id = p_document_id)))
2547: AND entity_type = p_entity_type
2548: AND latest_external_flag = 'Y'
2549: AND revision_num < p_revision_num

Line 4072: PO_LINES_ALL POL

4068: ATTR.program_update_date,
4069: ATTR.last_updated_program,
4070: 'Y' -- latest_external_flag
4071: FROM PO_ATTRIBUTE_VALUES ATTR,
4072: PO_LINES_ALL POL
4073: WHERE ATTR.po_line_id = POL.po_line_id
4074: AND POL.po_header_id = p_po_header_id;
4075:
4076: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into ATTR archive='||SQL%rowcount); END IF;

Line 4479: PO_LINES_ALL POL

4475: TLP.program_id,
4476: TLP.program_update_date,
4477: TLP.last_updated_program
4478: FROM PO_ATTRIBUTE_VALUES_TLP TLP,
4479: PO_LINES_ALL POL
4480: WHERE TLP.po_line_id = POL.po_line_id
4481: AND POL.po_header_id = p_po_header_id;
4482:
4483: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into TLP archive='||SQL%rowcount); END IF;