DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 672: from fnd_attached_documents

668: x_resultout out NOCOPY varchar2)is
669:
670: cursor get_attachments(l_shipment_header_id number) is
671: select pk1_value
672: from fnd_attached_documents
673: where entity_name='RCV_LINES'
674: and pk1_value in (select shipment_line_id
675: from rcv_shipment_lines
676: where shipment_header_id=l_shipment_header_id);

Line 715: from fnd_attached_documents

711: /*
712: l_progress := 'POS_WCAPPROVE_PVT.get_wc_attributes: 02.';
713: select count(*)
714: into l_attach_count
715: from fnd_attached_documents
716: where entity_name =' RCV_LINES'
717: and pk1_value in (select shipment_line_id
718: from rcv_shipment_lines
719: where shipment_header_id=l_shipment_header_id);