APPS.POS_CREATE_ASN dependencies on RCV_HEADERS_INTERFACE

Line 152: from rcv_headers_interface

148: /* Commented out ship_to_location */
149:
150: select count(*)
151: into x_count
152: from rcv_headers_interface
153: where ship_to_organization_id = p_ship_to_org_id_t
154: --and location_id = x_ship_to_location_id
155: and vendor_id = P_VENDOR_ID
156: and vendor_site_id = P_VENDOR_SITE_ID

Line 165: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL

161: if x_count < 1 then
162:
163: x_progress := '020' ;
164:
165: SELECT RCV_HEADERS_INTERFACE_S.NEXTVAL
166: INTO l_header_id
167: from dual;
168:
169: x_progress := '030' ;

Line 171: insert into rcv_headers_interface

167: from dual;
168:
169: x_progress := '030' ;
170:
171: insert into rcv_headers_interface
172: (HEADER_INTERFACE_ID ,
173: GROUP_ID ,
174: PROCESSING_STATUS_CODE ,
175: -- PROCESSING_REQUEST_ID ,

Line 268: from rcv_headers_interface

264: ELSE
265:
266: SELECT header_interface_id
267: into l_header_id
268: from rcv_headers_interface
269: where ship_to_organization_id = p_ship_to_org_id_t
270: --and location_id = x_ship_to_location_id
271: and vendor_id = P_VENDOR_ID
272: and vendor_site_id = P_VENDOR_SITE_ID

Line 844: from rcv_transactions_interface rti, rcv_headers_interface rhi

840:
841: -- All PO's for a particular group id should have the same org_id
842: select max(po_header_id)
843: into l_po_header_id
844: from rcv_transactions_interface rti, rcv_headers_interface rhi
845: where rhi.group_id = p_groupId
846: and rhi.header_interface_id = rti.header_interface_id
847: group by rti.header_interface_id;
848: