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 51: po_document_types_vl pdt

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