DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE dependencies on PO_DOCUMENT_TYPES_VL

Line 29: po_document_types_vl pdt

25: poh.type_lookup_code, --
26: poh.revision_num, --
27: NVL(poh.conterms_exist_flag, 'N') --
28: from po_headers poh,
29: po_document_types_vl pdt
30: where poh.agent_id = x_old_buyer_id
31: and nvl(poh.authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','INCOMPLETE','REJECTED')
32: and nvl(poh.closed_code,'OPEN') not in ('CLOSED','FINALLY CLOSED')
33: and nvl(poh.cancel_flag,'N') = 'N'

Line 52: po_document_types_vl pdt

48: pdt.type_name,
49: por.po_release_id--8551445
50: from po_releases por,
51: po_headers poh,
52: po_document_types_vl pdt
53: where por.po_header_id = poh.po_header_id
54: and por.agent_id = x_old_buyer_id
55: and nvl(por.authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','INCOMPLETE','REJECTED')
56: and nvl(por.closed_code,'OPEN') not in ('CLOSED','FINALLY CLOSED')