APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 70: v_receipt_num RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;

66:
67: result BOOLEAN;
68: req_id NUMBER;
69:
70: v_receipt_num RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;
71: v_inv_org_id NUMBER;
72: v_source VARCHAR2(25);
73: v_shipment_header_id NUMBER;
74: v_shipment_line_id NUMBER;

Line 101: FROM Rcv_Shipment_Headers

97: CURSOR Fetch_Shipment_Line_Id_Cur( invorg IN NUMBER, receiptnum IN VARCHAR2 ) IS
98: SELECT Shipment_Line_Id, Shipment_Header_Id
99: FROM Rcv_Shipment_Lines
100: WHERE Shipment_Header_Id IN ( SELECT Shipment_Header_Id
101: FROM Rcv_Shipment_Headers
102: WHERE Receipt_Num = receiptnum )
103: AND Po_Line_location_Id = ( SELECT Line_Location_Id
104: FROM Po_Distributions_All
105: WHERE Po_Distribution_Id = pr_new.Po_Distribution_Id )

Line 130: FROM rcv_shipment_headers rsh, rcv_transactions rt

126: AND NVL(org_id, 0) = NVL(v_org_id, 0);
127:
128: CURSOR count_receipts(p_pck_slip VARCHAR2, ven_id NUMBER, cpv_transaction_type VARCHAR2 ) IS
129: SELECT DISTINCT rsh.receipt_num, rsh.shipment_header_id
130: FROM rcv_shipment_headers rsh, rcv_transactions rt
131: WHERE rsh.shipment_header_id = rt.shipment_header_id
132: AND rsh.packing_slip = p_pck_slip
133: AND rsh.vendor_id = ven_id
134: AND rt.transaction_type = cpv_transaction_type;