APPS.RCV_DISTRIBUTIONS_S dependencies on RCV_SHIPMENT_LINES

Line 69: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE ; -- bug 9742420

65: x_project_id PO_DISTRIBUTIONS.project_id%type; -- bug 3867151
66: x_task_id PO_DISTRIBUTIONS.task_id%type; -- bug 3867151
67: l_clm_document VARCHAR2(1) := 'N'; -- Whether its a CLM document or Not
68:
69: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE ; -- bug 9742420
70: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE; --bug 9742420
71:
72: BEGIN
73:

Line 94: FROM rcv_shipment_lines

90: SELECT Nvl(asn_line_flag,'N'),
91: po_distribution_id
92: INTO l_asn_line_flag,
93: l_po_distribution_id
94: FROM rcv_shipment_lines
95: WHERE shipment_line_id = X_SHIPMENT_LINE_ID ;
96:
97: IF l_asn_line_flag = 'Y' THEN
98: IF X_po_distributions_id IS NULL THEN