APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 98: v_receipt_num RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;

94:
95: result BOOLEAN;
96: req_id NUMBER;
97:
98: v_receipt_num RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;
99: v_inv_org_id NUMBER;
100: v_source VARCHAR2(25);
101: v_shipment_header_id NUMBER;
102: v_shipment_line_id NUMBER;

Line 129: FROM Rcv_Shipment_Headers

125: CURSOR Fetch_Shipment_Line_Id_Cur( invorg IN NUMBER, receiptnum IN VARCHAR2 ) IS
126: SELECT Shipment_Line_Id, Shipment_Header_Id
127: FROM Rcv_Shipment_Lines
128: WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
129: FROM Rcv_Shipment_Headers
130: WHERE Receipt_Num = receiptnum )
131: AND Po_Line_location_Id = ( SELECT Line_Location_Id
132: FROM Po_Distributions_All
133: WHERE Po_Distribution_Id = pr_new.Po_Distribution_Id )

Line 158: FROM rcv_shipment_headers rsh, rcv_transactions rt

154: AND NVL(org_id, 0) = NVL(v_org_id, 0);
155:
156: CURSOR count_receipts(p_pck_slip VARCHAR2, ven_id NUMBER, cpv_transaction_type VARCHAR2 ) IS
157: SELECT DISTINCT rsh.receipt_num, rsh.shipment_header_id
158: FROM rcv_shipment_headers rsh, rcv_transactions rt
159: WHERE rsh.shipment_header_id = rt.shipment_header_id
160: AND rsh.packing_slip = p_pck_slip
161: AND rsh.vendor_id = ven_id
162: AND rt.transaction_type = cpv_transaction_type;